Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a problem with the cumulative values.
I have built a measure that allows me to display the cumulative values month by month.
The question is: I would like, when I filter on a month, that the map gives me the value of the cumulative measure for this month, and not the value of this month not cumulated
Thanks in advance for your help!
87 is the sum of the last cumulated values of France and Germany
When I click on the curve for Germany in the second month, I would like it to show me 22 instead of 12 (which is the non-cumulative value of the second month)
My measure is
Solved! Go to Solution.
Hi @Thomas94401
Try this:
Cumulative number =
VAR _Max =
MAX ( 'Table'[Month] )
RETURN
CALCULATE (
SUM ( 'Table'[Number] ),
FILTER ( ALL ( 'Table'), 'Table'[Month] <= _Max )
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @Thomas94401
Try this:
Cumulative number =
VAR _Max =
MAX ( 'Table'[Month] )
RETURN
CALCULATE (
SUM ( 'Table'[Number] ),
FILTER ( ALL ( 'Table'), 'Table'[Month] <= _Max )
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/