Cumulative total using Rank

[Simonchaney]

Good Morning All,

For a while now I have been trying to perfect a Dynamic Pareto analysis and have managed to solve most problems the last one I am stuck with is that when I am calculating a dynamic cumulative total if the count of faults is the same it doesnt add one of the totals to the cumulative value

Below is the measure I am using to trying to use

Calculate([count of fault codes],( TOPN ( [ranking Dynamic], ALL ( 'Fault Code Lookup'[Cause] ), [Count of Fault Codes]) )

ranking dynamic and count of fault codes are both measures in themselves

Any help to solve this issue would be greatly appreciated

[Simonchaney]

Was wondering if anyone has managed to come up with a solution?

[v-chuncz-msft]

@Simonchaney,

You may try using Quick measure Running total.

[Simonchaney]

Good Morning Sam

After trying multiple combinations in Power BI under quick measure i am afraid that it still wont calculate the running Total

do you have any other ideas?