Measure as filter

[OmPrakashMahto]

I have a dashboard where I would like %age measure to be used as filter. But looks like PowerBI doesn't allow measure as filter. If I try to create this as column then use as filter then %age calculation goes wrong as it aggregates the data on the dashbboard. Can someone suggest how can this be resolved? 

[v-zhangti · Accepted solution]

Hi, @OmPrakashMahto 

Measure can be used as a filter, but you need to convert the method.

Sample data:

Measurefilter = IF([Measure%]>0.5,1,0)

Hope this method helps you.

Best Regards,

Community Support Team _Charlotte

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

[FreemanZ]

yes, filter takes columns but not measure. what code do you have for the the measure? it needs to be changed lightly for columns.

[OmPrakashMahto]

DIVIDE(Fact_Sales[AdSales],Fact_Sales[Sales],0)