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 calculation goes wrong as it aggregates the data on the dashbboard. Can someone suggest how can this be resolved? 

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.

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

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

  • 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.