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
I'm still a simple user of powebi,
I created a measure to calculate the Month-over-month cost variation (MoMDiff) and in the results I have negative and positives numbers.
The table below is filtered MoMdiff > 0.
I would like to sum and isoleted the positive numbers and negative numbers to have a card that displays both sum for better analysis.
Please it would be great if some one could help me.
Thank you in advance
Solved! Go to Solution.
maybe you can try this
Measure = sumx(FILTER(VALUES('Table'[resourceid]),[MoMDiff]>0),[MoMDiff] )
Measure 2 = SUMX(FILTER(VALUES('Table'[resourceid]),[MoMDiff]<0),[MoMDiff] )
Proud to be a Super User!
maybe you can try this
Measure = sumx(FILTER(VALUES('Table'[resourceid]),[MoMDiff]>0),[MoMDiff] )
Measure 2 = SUMX(FILTER(VALUES('Table'[resourceid]),[MoMDiff]<0),[MoMDiff] )
Proud to be a Super User!
Hi Ryan,
Thank you so much for your awnser, it worked fine.
Regards
you are welcome
Proud to be a Super User!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |