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...
johnbasha33
Super User
Super UserRunning 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
