topic Re: Revverse cumulative error in DAX Commands and Tips

Revverse cumulative error

Samarth-Borade — Thu, 02 Feb 2023 09:39:52 GMT

RevCum_Revenue123 = VAR RunningTotal= CALCULATE([sss], FILTER(ALL(grp[Rev]),grp[Rev]>=MIN(grp[Rev])))

RETURN IF(ISBLANK([sss]),BLANK(),RunningTotal)

here [sss] = SUM(grp[Rev])

when i remove customer code, it will only show the entire sum.I want to show the reverse cumulative ,

i.e in descending order: 9031 then 9031+8984 then 9031+8984+4792.

Re: Revverse cumulative error

tamerj1 — Thu, 02 Feb 2023 11:02:23 GMT

Hi Samarth-Borade
What is the result that you're looking for?

Re: Revverse cumulative error

Samarth-Borade — Thu, 02 Feb 2023 11:05:32 GMT

Re: Revverse cumulative error

Samarth-Borade — Thu, 02 Feb 2023 11:25:26 GMT

Any leads?

Re: Revverse cumulative error

tamerj1 — Thu, 02 Feb 2023 15:56:18 GMT

Samarth-Borade
Please refer to attached sample file with the proposed solution

RevCum_Revenue = VAR CurrentRevenue = SUM ( 'Table'[Revenu] ) VAR T1 = SELECTCOLUMNS ( ALLSELECTED ( 'Table'[Customer Cod] ), "@Revenue", CALCULATE ( SUM ( 'Table'[Revenu] ) ) ) VAR T2 = FILTER ( T1, [@Revenue] >= CurrentRevenue ) RETURN SUMX ( T2, [@Revenue] )