Filter measure in a table

[AJ42]

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

Thanks in advance for any help

[v-zhenbw-msft]

Hi @AJ42 ,

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

1. Create a parameter,

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,

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.

[AJ42]

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? 

Thank you for all your help with this