Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
thaonguyen
Frequent Visitor

If not filter, show value table with condition

Hi all, 

I have a problem about slicer and table list.

I have an example table:

thaonguyen_0-1663063901086.png

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.

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @thaonguyen 

Please follow attached sample file for the solution

1.png1.png2.png

 

 

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

 

 

View solution in original post

3 REPLIES 3
thaonguyen
Frequent Visitor

Hi @tamerj1 ,

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

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

tamerj1
Super User
Super User

Hi @thaonguyen 

Please follow attached sample file for the solution

1.png1.png2.png

 

 

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

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.