Forum Discussion
Cumulative Total
I am trying to create a Pareto Chart using Dax Formulas for the set of 5 metrics in a column (Error Column below)...I have created the following Dax Measures: Error Volume = Data from the data sourc...
Hi mol_ad ,
You can try formula like below:
Running Total =
VAR CurrentError =
SELECTEDVALUE ( 'YourTableName'[Errors] )
RETURN
CALCULATE (
SUM(YourTableName[Error Volume]),
FILTER (
ALLSELECTED ( 'YourTableName'[Errors] ),
'YourTableName'[Errors] <= CurrentError
)
)ratio: =
DIVIDE (
[Running total],
CALCULATE ( SUM ( 'YourTableName'[Error Volume] ), ALL ( 'YourTableName' ) )
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! However, I am attempting to create a Pareto Chart with the data and therefore will be sorting the Errors based on Error Volume from largest to smallest and not alphabetically.
Below is what I am looking to accomplish.
Error E.V. R.T. Chart %
| Timeliness | 11 | 11 | 34.38% |
| Appropriate Notes | 11 | 22 | 68.75% |
| Appropriate Escalation | 4 | 26 | 81.25% |
| Appropriate Activity Code | 3 | 29 | 90.63% |
| Resolution | 3 | 32 | 100.00% |
Here is the resulting table I get when sorting the Errors by Error Volume:
| Errors | Error Volume | Running Total |
| Appropriate Notes | 11 | 18 |
| Timeliness | 11 | 32 |
| Appropriate Escalation | 4 | 7 |
| Appropriate Activity Code | 3 | 3 |
| Resolution | 3 | 21 |
| Total | 32 |