Help with ISCROSSFILTERED between two tables.

[jvince]

Hello, 

I current have a dashboard that contains two tables that filter against each other, I would like the second table to be blank until a value is selected in the first table.  Right now the data for each table is stored in two queries related by one column in each.

Currently, I am using a measure to check cross filtering:

Measure = if(ISCROSSFILTERED(Table[ColumnToBeFiltered]), "Y", "N")

I have applied this measure to "Visual level filters" in my second table with: Show items when the value:, is, "Y"

Right now, the second table is always blank, regardless is the measure returns  "Y" or "N"  - I have checked that the measure does return the correct value by placing it in a card. 

I would like for the second table to populate when the measure returns "Y", but so far I can't get that to work.

Any help would be appreciated. Thank you.

[Anonymous · Accepted solution]

@jvince,

I create a measure using your DAX in the second table and everything works well. Please review the following screenshots. Could you please share dummy data of your two tables?

Regards,

Lydia

[jvince]

Hello Lydia,

Thank you for your response.

I used your example and it worked perfectly. Given that your example is almost identical to mine - I wasn't sure why it didn't work until I used ISFILTERED in the place of ISCROSSFILTERED and it worked perfectly.