Forum Discussion

OmPrakashMahto's avatar
OmPrakashMahto
Regular Visitor
3 years ago
Solved

Measure as filter

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 calcula...
Need Help
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

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.