Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |