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

Running Total Becomes Incorrect When I add Legend

Hi Everyone,

With the Support of this community, I was able to get the Running Total against Week Numbers. WEEK Number is on X AXIS and my Counts are on Y AXIS and It is ALL OK.

Now, What is happening is when I drag Status to Legend, The Running Total Becomes Incorrect. The running total also shows downward trend which should not be.

I have this  Sample data 

Week NumberCOUNTStatus
4285A
423C
4210D
4233G
4350A
432B
433C
433E
4335F
4390G
4380H
4457A
442B
4417C
442E
4446F
442G
4423H
4515A
452B
4530C
4514E
4589F
4588G
4599H
469A
467C
4650G
4620H
461I
471A
473C
471F
478G
479H
472I

 

I should be getting This, which I created in Tableau

Actual Running.PNGFINAL VIEW DESIRED

 

But I am Getting This

 

getting.PNGThis is Incorrect

Please advice

Thanks

Deepak

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Running Total Becomes Incorrect When I add Legend

in x axis, click arrow next to you field and select "Show items with no data" and see if that helps.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





drrai66 Member
Member

Re: Running Total Becomes Incorrect When I add Legend

Oh...Great...that's it ..Hurrey..Thanks Thanks..

Deepak

8 REPLIES 8
Phil_Seamark Super Contributor
Super Contributor

Re: Running Total Becomes Incorrect When I add Legend

Hi @drrai66

 

I think this calculated measure is close

 

My Running Total = CALCULATE(
						SUM('Table1'[COUNT]),
						FILTER(
							ALLEXCEPT(
								'Table1',
								Table1[Status]
								),
							MAX('Table1'[Week Number]) >= 'Table1'[Week Number])
							)

rt.png

 

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Super User
Super User

Re: Running Total Becomes Incorrect When I add Legend

Hi @drrai66,

 

Try this measure

 

=CALCULATE([Total],FILTER(ALL(Data[Week Number]),Data[Week Number]<=MAX(Data[Week Number])))

 

Hope this helps.

 

Untitled.png

drrai66 Member
Member

Re: Running Total Becomes Incorrect When I add Legend

Hi Ashish,

Can you attach your Solution.

Thanks

Deepak

Super User
Super User

Re: Running Total Becomes Incorrect When I add Legend

Hi,

 

What problem are you facing when trying my suggeted formula.  Share the download link of your PBI file.

Super User
Super User

Re: Running Total Becomes Incorrect When I add Legend

in x axis, click arrow next to you field and select "Show items with no data" and see if that helps.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





drrai66 Member
Member

Re: Running Total Becomes Incorrect When I add Legend

Oh...Great...that's it ..Hurrey..Thanks Thanks..

Deepak

Super User
Super User

Re: Running Total Becomes Incorrect When I add Legend

Nice, that was easy Smiley Happy






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





drrai66 Member
Member

Re: Running Total Becomes Incorrect When I add Legend

Yes, But Being new to Power BI I strugged to get it...You just appeared from Nowhere and Saved the day...

Thanks a lot

Deepak

Helpful resources

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.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 48 members 1,223 guests
Please welcome our newest community members: