SELECT Based on User Selection

[Qiro]

I'm using the following expression to reference data from another table:

ANY(SELECT(Asset Log[Hours], AND([_THISROW].[ORS] = [Associate Name], [_THISROW].[Date] = [Date])))

It seems to work intermittently, sometimes showing data correctly and other times showing nothing.

It depends on user selection from a dropdown for the match for [Associate Name] and a date selector for the [Date].

Any ideas what's going doing wrong?

[dbaum]

Where is your expression? A slice? A column? If it's a column, are you sure it's even being triggered to recalculate? For instance, if it's a column in a table different than the table with columns for the "user selection", then it won't recalculate automatically just because the user selection changes.

[Swoopy · Accepted solution]

Try this in valid-if of [Date] column,

SELECT(Asset Log[Date], [_THISROW].[ORS] = [Associate Name])

This forces the dropdown to show only valid dates.

[Qiro]

Yep, got this one to work, thank you.