Forum Discussion
Running Total for no Calendar table
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]
)
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.
5 Replies
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.