Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Chapin4u
Microsoft Employee
Microsoft Employee

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

2018-06-13_18-03-27.jpg

 

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

2 ACCEPTED SOLUTIONS

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.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

 

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Really a great solution, thank you!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.