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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AJ42
Helper I
Helper I

Filter measure in a table

Hello

 

I am looking for a way to filter out measures below a specified figure. With the example below i would like to filter out any measure below 10%. I have tried using the visual filter in Power Bi desktop however this filters the total and not the indervidual measures. I created this table using the helpful steps from @v-lid-msft in the below link. 

 

https://community.powerbi.com/t5/Desktop/Getting-Teams-usage-in-from-the-last-7-days/m-p/1010700

 

image.png

 

Thanks in advance for any help

2 REPLIES 2
v-zhenbw-msft
Community Support
Community Support

Hi @AJ42 ,

 

We can create a parameter and a measure to meet your requirement.

 

1. Create a parameter,

 

filter 1.jpg

 

2. Then we can create a measure, and replace your measure with this measure in matrix.

 

Measure = IF([%]<=[Parameter Value],BLANK(),[%])

 

3. At last we can get the result like this,

 

filter 2.jpg

 

filter 3.jpg

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

 

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-zhenbw-msft 

 

Thank you for your help with this, i have given it a go and it is what i am looking for. However i have come across a strange issue. It may be how i have my data stored but didnt know if there wasd a simple fix for it? 

 

On the visual i also have a visual filter set which filters to only show students. When i filter 20% and above some of the column totals become blank. Im also not 100% sure the 10% filter is giving me the correct total. Am i missing something obvious? 

 

image.pngimage.pngimage.png

 

Thank you for all your help with this

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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