Forum Discussion
Tableau's Running Total But In Power BI
Hi,
I followed this video to create a cumulative % in Power BI. The videos works correctly for my data because I have similar dataset to the one in the video. I have a categorical column (similar to states in the video), and a numerical column (similar to total revenue in the video). So the video works almost perfectly for my case. However, i'm facing a problem whereby this formula works when I only have different values as my 'total revenue'. Now, i have two 'states' which have the same 'total revenue'. This caused my pareto or cumulative % line to be flat (horizontal) on those two 'states' before curving upwards again.
Does this make sense? To my understanding, the line should curve upwards anyway. What I notice is that the cumulative quantity adds the same values of the two 'states' together, but why? How do I make it not add two same values?
This is the video: Create A Pareto Chart In Power BI Using DAX Function Combinations (youtube.com)
Anonymous , Use window function
Cumm Based on Measure = CALCULATE([Your Measure], Window(1,ABS,0,REL, ALLSELECTED('Table'[State]),ORDERBY([Your Measure],Desc, 'Table'[State], asc)))
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f
1 Reply
Anonymous , Use window function
Cumm Based on Measure = CALCULATE([Your Measure], Window(1,ABS,0,REL, ALLSELECTED('Table'[State]),ORDERBY([Your Measure],Desc, 'Table'[State], asc)))
Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f