Forum Discussion

thaonguyen's avatar
thaonguyen
Frequent Visitor
4 years ago
Solved

If not filter, show value table with condition

Hi all, 

I have a problem about slicer and table list.

I have an example table:

I have a slicer BU. When I don't filter any slicers, I want the table only shows records that have NOTE = off/ null.

If I filter BU, the table will show all NOTE.

Please help me with it,

Thanks so much.

 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi thaonguyen 

    Please follow attached sample file for the solution

     

     

    Filter Measure = 
IF (
    ISFILTERED ( 'BU Selection'[BU] ),
    1,
    COUNTROWS ( 
        FILTER ( Data, Data[NOTE] IN { "off", BLANK ( ) } )
    )
)

     

     

3 Replies

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      thaonguyen 
      I notice a small mistake in the code. Please refer to the updated one in the "Marked as accepted solution" reply.

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi thaonguyen 

    Please follow attached sample file for the solution

     

     

    Filter Measure = 
IF (
    ISFILTERED ( 'BU Selection'[BU] ),
    1,
    COUNTROWS ( 
        FILTER ( Data, Data[NOTE] IN { "off", BLANK ( ) } )
    )
)