Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IsFiltered for 2 slicers

Hi,    I'm following this article and trying to do isfiltered for 2 slicers.  https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/   I want to do this part with 2 slic...
Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi Anonymous 

     

    Try this:

    Check Filtered = 
IF(
    ISFILTERED( Table1[Column1] )
    && ISFILTERED( Table2[Column2] ),
    1,
    0
)

     

    Best regards,
    Martyn


    If I answered your question, please help others by accepting it as a solution.

     

MartynRamsden's avatar
MartynRamsden
Solution Sage
6 years ago

Hi Anonymous 

 

Try this:

Check Filtered = 
IF(
    ISFILTERED( Table1[Column1] )
    && ISFILTERED( Table2[Column2] ),
    1,
    0
)

 

Best regards,
Martyn


If I answered your question, please help others by accepting it as a solution.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    MartynRamsden Thank you, that worked great. Do you also know the command for ISFILTERED with OR?

    • MartynRamsden's avatar
      MartynRamsden
      Solution Sage
      6 years ago

      Hi Anonymous 

       

      The DAX operator for OR is a double pipe '||' so your expression would be:

      Check Filtered = 
IF(
    ISFILTERED( Table1[Column1] )
    || ISFILTERED( Table2[Column2] ),
    1,
    0
)

       

      Best regards,
      Martyn


      If I answered your question, please help others by accepting it as a solution.