Forum Discussion

AJ42's avatar
AJ42
Icon for Helper I rankHelper I
6 years ago

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 Powe...
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
AJ42
Icon for Helper I rankHelper I
6 years ago

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