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])

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Try this:
Measure =
VAR LastVisible = MAX ( TABLE[Rank] )
RETURN CALCULATE (
SUM(VALUES),
TABLE[RANK] <= LastMonthVisible
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous is not possible because rank is a measure, it is not stored in a table.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Instead of a measure, you can create a calculated column for the same.