Forum Discussion

mol_ad's avatar
mol_ad
Frequent Visitor
2 years ago

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...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
2 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

WINDOW function (DAX) - DAX | Microsoft Learn

 

Running total: = 
CALCULATE (
    SUM ( 'Follow-Up Team'[Error Volume] ),
    WINDOW (
        1,
        ABS,
        0,
        REL,
        ALL ( 'Follow-Up Team' ),
        ORDERBY (
            CALCULATE ( SUM ( 'Follow-Up Team'[Error Volume] ) ), DESC,
            'Follow-Up Team'[Errors], ASC
        ),
        ,
        ,
        MATCHBY ( 'Follow-Up Team'[Errors] )
    )
)

 

ratio: = 
DIVIDE (
    [Running total:],
    CALCULATE ( SUM ( 'Follow-Up Team'[Error Volume] ), ALL ( 'Follow-Up Team' ) )
)