cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chapin4u Member
Member

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

Accepted Solutions
Chapin4u Member
Member

Re: Running Total for no Calendar table

Super User
Super User

Re: Running Total for no Calendar table

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

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Running Total for no Calendar table

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 Member
Member

Re: Running Total for no Calendar table

Super User
Super User

Re: Running Total for no Calendar table

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

View solution in original post

Chapin4u Member
Member

Re: Running Total for no Calendar table

Really a great solution, thank you!

Highlighted
Super User
Super User

Re: Running Total for no Calendar table

You are welcome.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 276 members 3,227 guests
Please welcome our newest community members: