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
I should be getting This, which I created in Tableau
FINAL VIEW DESIRED
But I am Getting This
This is Incorrect
Go to Solution.
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.
Oh...Great...that's it ..Hurrey..Thanks Thanks..
I think this calculated measure is close
My Running Total = CALCULATE(
MAX('Table1'[Week Number]) >= 'Table1'[Week Number])
Proud to be a Datanaut!
Try this measure
=CALCULATE([Total],FILTER(ALL(Data[Week Number]),Data[Week Number]<=MAX(Data[Week Number])))
Hope this helps.
Can you attach your Solution.
What problem are you facing when trying my suggeted formula. Share the download link of your PBI file.
Nice, that was easy
Yes, But Being new to Power BI I strugged to get it...You just appeared from Nowhere and Saved the day...
Thanks a lot
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.