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/...
  • 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 ( ) } )
    )
)

     

     

thaonguyen's avatar
thaonguyen
Frequent Visitor
4 years ago

Hi tamerj1 ,

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

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.