Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
But I am Getting This
Please advice
Thanks
Deepak
Solved! Go to Solution.
in x axis, click arrow next to you field and select "Show items with no data" and see if that helps.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @drrai66,
Try this measure
=CALCULATE([Total],FILTER(ALL(Data[Week Number]),Data[Week Number]<=MAX(Data[Week Number])))
Hope this helps.
Hi Ashish,
Can you attach your Solution.
Thanks
Deepak
Hi,
What problem are you facing when trying my suggeted formula. Share the download link of your PBI file.
in x axis, click arrow next to you field and select "Show items with no data" and see if that helps.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Oh...Great...that's it ..Hurrey..Thanks Thanks..
Deepak
Nice, that was easy 🙂
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
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]) )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |