Creating Filter from mesure

[Anonymous]

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 in one measure in order to use a filter to switch between them easily.

Best regards,

Kerrout Anis

[Anonymous]

Hello,

It is impossible to create a filter from value. In my case ( screen) Raw , pack, P3rd, OVE are numbers. I would like to create a new column  composed of ( raw, pack, P3rd ,OVE)  so that i can use the filter that shows Raw , pack, P3rd, OVE.

Bet regards,

Kerout Anis

[danextian]

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] ) )

[Anonymous]

thank you @danextian , can you show me where is the Field Parameter ?

[danextian]

Here's a demo of that: https://www.youtube.com/watch?v=V6WchPDZibI 

[Shishir22 · Accepted solution]

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.

[Shishir22]

Hello @Anonymous ,

Not very clear. Request you to please elaborate with example so that we can help you.