Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Cumulative Balance Name wise Total

I need result for cumulative balance as doesn't works its giving result as zero for DAX Formula, pls guide Basically take a highest sales value and cumulative balance as mentioned on below table.  ...
Need Help
  • Bmejia's avatar
    Bmejia
    1 year ago

    Hi,

    If it is a cumulative from largest Salest to small try this,

    1st. Create a measure with your sales total (it might be your measure[Sales] value already
      Example:

             Measure = CALCULATE(SUM((File[Sales Total])))
    Then another measure as, 
           Cumulative Sum from Largest =
               VAR CurrentValue = [Measure]  
           RETURN
              CALCULATE(
                                 [Measure],  
                                            FILTER(ALL(YourTable),
                                           [Measure] >= CurrentValue
        )


v-veshwara-msft's avatar
v-veshwara-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.