If not filter, show value table with condition

[thaonguyen]

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.

[thaonguyen]

Hi @tamerj1 ,

I really got it. Thank you so much for your comment

[tamerj1]

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

[tamerj1 · Accepted solution]

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 ( ) } )
    )
)