Forum Discussion
Resolver IRunning 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
Please advice
Thanks
Deepak
in x axis, click arrow next to you field and select "Show items with no data" and see if that helps.
Oh...Great...that's it ..Hurrey..Thanks Thanks..
Deepak
8 Replies
- Phil_Seamark
Microsoft Employee
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]) ) - Ashish_Mathur
Super User
Hi drrai66,
Try this measure
=CALCULATE([Total],FILTER(ALL(Data[Week Number]),Data[Week Number]<=MAX(Data[Week Number])))
Hope this helps.
drrai66Hi Ashish,
Can you attach your Solution.
Thanks
Deepak
- Ashish_Mathur
Hi,
What problem are you facing when trying my suggeted formula. Share the download link of your PBI file.
