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...
Running Total =
VAR CurrentError = MAX('Follow-Up Team'[Errors])
RETURN
CALCULATE(
SUM('Follow-Up Team'[Error Volume]),
FILTER(
ALL('Follow-Up Team'[Errors]),
'Follow-Up Team'[Errors] <= CurrentError
)
)
When using this formula, I am still running into the same problem. When the errors are sorted alphabetically it is working as expected. However, I am not sorting alphabetically - I am sorting by error volume (see the following):
This is what I am looking for:
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 using your given formula:
| 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 |