cancel
Showing results for
Did you mean:
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 Number COUNT Status 42 85 A 42 3 C 42 10 D 42 33 G 43 50 A 43 2 B 43 3 C 43 3 E 43 35 F 43 90 G 43 80 H 44 57 A 44 2 B 44 17 C 44 2 E 44 46 F 44 2 G 44 23 H 45 15 A 45 2 B 45 30 C 45 14 E 45 89 F 45 88 G 45 99 H 46 9 A 46 7 C 46 50 G 46 20 H 46 1 I 47 1 A 47 3 C 47 1 F 47 8 G 47 9 H 47 2 I

I should be getting This, which I created in Tableau

FINAL VIEW DESIRED

But I am Getting This

This is Incorrect

Thanks

Deepak

2 ACCEPTED SOLUTIONS

Accepted Solutions
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.

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

Member

Re: Running Total Becomes Incorrect When I add Legend

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

Deepak

8 REPLIES 8
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])
)```

Proud to be a Datanaut!

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.

Member

Hi Ashish,

Thanks

Deepak

Super User

Hi,

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.

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

Member

Re: Running Total Becomes Incorrect When I add Legend

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

Deepak

Super User

Re: Running Total Becomes Incorrect When I add Legend

Nice, that was easy

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

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

Announcements

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.

Power Platform Summit North America

Register by September 5 to save \$200

PBI Community Highlights

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

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 90 members 1,596 guests
Recent signins: