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.
Hi,
Is it possible to have a measure to take the difference of the two parameters in a visual?
I have sales measures for each year going back as far as 5 years. I'm planning on put two parameters into a matrix or table so the end user can select the two years of sales they want to compare. Is it possible to have a measure to just take the difference of the two parameters without have to build out the measures separately and doing something like Switch depending on selection?
hi @loafers
seems yes, just try it.
e.g.
Diff =
CALCULATE([measure], data[year]=SELECTEDVALUE(parameter1[parameter1]))
-
CALCULATE([measure], data[year]=SELECTEDVALUE(parameter2[parameter2]))
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |