Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating Filter from mesure

Hello,   I would like to know if there is a DAX formula to create a filter using existing mesure. I would like that all the differentes values ( measures) Raw, Pack, P3rd, COGS OVE, ... are grouped...
Need Help
Show and Tell
Tips and Tricks
  • Shishir22's avatar
    Shishir22
    4 years ago

    Hello Anonymous -

     

    This should help you out-

    https://youtu.be/-nqEv2YXLsU

    Please mark it as answer if it resolves your issue. Kudos are also appreciated.

     

     

     

     

danextian's avatar
danextian
Super User
4 years ago

Hi Anonymous ,

If you want to be able to switch between measures by just clicking a button/slicer item, you can you the Field Parameters feature available as a preview in the May 2022 release of Power BI Desktop.  You can also use measure to filter another measure but depending the current filter context and your data model, the formula below might not give you the result you expect.

NewMeasure =
CALCULATE ( [MyMeasure], FILTER ( Table, Table[Column] = [MyOtherMeasure] ) )