Forum Discussion

Simonchaney's avatar
Simonchaney
Frequent Visitor
8 years ago

Cumulative total using Rank

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

3 Replies

    • Simonchaney's avatar
      Simonchaney
      Frequent Visitor
      8 years ago

      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?

  • Simonchaney's avatar
    Simonchaney
    Frequent Visitor
    8 years ago

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