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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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