Running Total for no Calendar table

[Chapin4u]

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]
)

[Chapin4u · Accepted solution]

Hi, here it's

https://indisersa-my.sharepoint.com/:u:/p/oknoke/Ee49R8Sw9lZGpezw6WXR39oBm8RQUsOTsJMsmZYe6JrovA?e=hH...

Tks

[Ashish_Mathur]

Hi,

I don't think we would need the Calendar or Year Table.  Share the link from where i can download your PBI file.

[Chapin4u · Accepted solution]

Hi, here it's

https://indisersa-my.sharepoint.com/:u:/p/oknoke/Ee49R8Sw9lZGpezw6WXR39oBm8RQUsOTsJMsmZYe6JrovA?e=hH...

Tks

[Ashish_Mathur · Accepted 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.

[Chapin4u]

Really a great solution, thank you!

[Ashish_Mathur]

You are welcome.