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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
sasdfasdfsad
Advocate II
Advocate II

Can't use Measure value in filter?

I'm following this Guy in a Cube but I can not get it work:

Nothing selected in Power BI Slicer? Then don't show data! - YouTube

 

sasdfasdfsad_0-1727995741770.png



Is Name Filtered = INT(ISFILTERED('Table'[Name]))


I then set the table to have an added visual filter for that Measure but the table is not responsive to the filter.  

sasdfasdfsad_1-1727995787654.png



When I make a selection in the slicer the "Is Name Filtered" value changes, but the table doesn't react.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @sasdfasdfsad ,

 

Thanks for @lbendlin reply!

 

@sasdfasdfsad The link you provided can't open, but there is another method about your question.

Create the measure and add it to Columns of Table visual.

Measure =  CALCULATE ( IF ( ISFILTERED ('Table'[Name] ), 1, 0 ), ALLSELECTED ('Table') )   

The modify the Filter and click "Apply filter".

vmengmlimsft_0-1728272005262.png

 

When I select nothing, the table shows nothing.

vmengmlimsft_1-1728272052237.png

 

 

 

 

Best regards,

Mengmeng Li

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi @sasdfasdfsad ,

 

Thanks for @lbendlin reply!

 

@sasdfasdfsad The link you provided can't open, but there is another method about your question.

Create the measure and add it to Columns of Table visual.

Measure =  CALCULATE ( IF ( ISFILTERED ('Table'[Name] ), 1, 0 ), ALLSELECTED ('Table') )   

The modify the Filter and click "Apply filter".

vmengmlimsft_0-1728272005262.png

 

When I select nothing, the table shows nothing.

vmengmlimsft_1-1728272052237.png

 

 

 

 

Best regards,

Mengmeng Li

lbendlin
Super User
Super User

The measure actually needs to have an impact on the rows that contribute to the visual.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Ah okay.

sasdfasdfsad_0-1728053827368.png



So the issue here then is that the measure when it applies to the data table IS returning 1 /True for filtered because it's evaluating for the row context of each table row and that is applying a filter....

So, is there a way to test if the slicer itself is filtered but NOT get stuck in the row context as I want the field the slicer is filtering to ALSO be displayed in the data table visual.


I just want to determine if the slicer on the page for "Name" has been checked.

If checked, show, if no selection made, don't show data.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

 

 

CustomerID Name OrderCount 
55Bob8453
129Jim0
985Sally453

 

 

Sadly I can't upload a file as I lack sufficient user astatus and I don't have access to any cloud based data storage from inside our firewall.  

If you watch the video again your will notice that the filter column is NOT part of the table visual.

 

lbendlin_0-1728064442213.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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