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 need help to create the running total of the third column of the left image. I do not have a calendar table, I just have Year Table on the right side of the image. The measure the third column is
% Countries vs World = DIVIDE([Sum Countries Mhl], [Sum World Mhl])
Pls help
I have always used this formula but know it won't work
RunningTotal =
SUMX (
FILTER (
ALLSELECTED ( 'Calendar'[DateKey] ),
'Calendar'[DateKey] <= MAX ( 'Calendar'[DateKey] )
),
[my_field]
)
Solved! Go to Solution.
Hi,
You may refer to my solution in this PBI file. Since your "% Countries vs World" measure does not add up to 100%, your and my measure do not match for the first country i.e. Italy (see image below). Thereafter my measure returns the correct result.
Hope this helps.
Hi,
I don't think we would need the Calendar or Year Table. Share the link from where i can download your PBI file.
Hi,
You may refer to my solution in this PBI file. Since your "% Countries vs World" measure does not add up to 100%, your and my measure do not match for the first country i.e. Italy (see image below). Thereafter my measure returns the correct result.
Hope this helps.
Really a great solution, thank you!
You are welcome.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |