Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I need help writing a DAX measure in which I have to calculate the difference between two selected measure in a field paramenter slicer.
Do I have to create a calculation group in Tabular Editor? If yes, can you guide me on how to do it?
es. Selecting EBITDA for the current year and the EBITDA of the previous year from the filter parameter slicer, I need to have the difference between theese two selected measure.
I Need to have this difference measure to be dynamic, based on the selected measere in the field paramenter slicer.
Can anyone help me??
Thanks in advance,
Luca
I solved it by creating two measures that shows the selected value order from the field parameters:
Parameter 1 = SELECTEDVALUE('Parameter1' [order])
Parameter 2 = SELECTEDVALUE('Parameter2' [order])
Then I created a Switch measure that looks a the above chosen values and their order:
Difference =
HI @some_bih
I need to have a dinamyc measure that appears only if I select those 2 measures in the field parameter slicer.
In the field parameter slicer I have multiple measures that don't need this "Difference AC - AP" measure to be showed.
Hi @L_G simple measure like below is ok for you?
Difference test= [EBTDA]-[EBTDAP]
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |