Forum Discussion

jvince's avatar
jvince
Frequent Visitor
8 years ago
Solved

Help with ISCROSSFILTERED between two tables.

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's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      jvince
      Frequent Visitor
      8 years ago

      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.