Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Accumulate Negative Values

Hi all !!   I need to make a pareto chart but with negative values, for this I need to accumulate the negative values from higher to lower.   The first step is to rank the negative totals from hi...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Thanks for your feedback.

    Based on your details, I modified my sample and the measures:

    Use below measure to calculate the rankx :

     

    Rankx = RANKX(ALL('Sample'),[ValuesMeasure],,DESC)

     

    Then use the below measure to generate the cumulative results:

     

    FinalResults = var a = [Rankx]
Return 
SUMX(FILTER(ALL('Sample'),[Rankx]<=a),[ValuesMeasure])

     

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

Thanks for your feedback.

Based on your details, I modified my sample and the measures:

Use below measure to calculate the rankx :

 

Rankx = RANKX(ALL('Sample'),[ValuesMeasure],,DESC)

 

Then use the below measure to generate the cumulative results:

 

FinalResults = var a = [Rankx]
Return 
SUMX(FILTER(ALL('Sample'),[Rankx]<=a),[ValuesMeasure])