Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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] ) )
Proud to be a Super User!
Here's a demo of that: https://www.youtube.com/watch?v=V6WchPDZibI
Proud to be a Super User!
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.
Hello @Anonymous ,
Not very clear. Request you to please elaborate with example so that we can help you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |