Forum Discussion

ansar's avatar
ansar
Helper II
4 years ago
Solved

Incorrect Cumulative Total / Running Total - Text field

Hi Dears, Need your help here   Am trying to create a measure to get cumulative total of a [Prov USD] (Measure summing provision amounts) based on customer name. Totals showing for other two column...
Need Help
  • ansar's avatar
    ansar
    4 years ago

    Greg_Deckler : In column 1(Cumulative Prov 2) is aggregating values from column 2(Prov USD) .The total showing in column 2 is not matching with the Column 1 where i have highlited in the image, 

     



    It got resolved once i removed the blanks

    Cumulative Value Prov =
    VAR thisCustProv = [Prov USD]
    VAR TotalProvAllCust =
    CALCULATE([Prov USD], ALL('Customer DB'[Cr. Name]))
    RETURN
    IF(ISBLANK([Prov USD]),BLANK(),
    CALCULATE(
    [Prov USD],
    FILTER(ALL('Customer DB'),[Prov USD]>=thisCustProv)
    ))

     

    Regards,

    Ansar



Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

ansar So what is not correct in your image?

ansar's avatar
ansar
Helper II
4 years ago

Greg_Deckler : In column 1(Cumulative Prov 2) is aggregating values from column 2(Prov USD) .The total showing in column 2 is not matching with the Column 1 where i have highlited in the image, 

 



It got resolved once i removed the blanks

Cumulative Value Prov =
VAR thisCustProv = [Prov USD]
VAR TotalProvAllCust =
CALCULATE([Prov USD], ALL('Customer DB'[Cr. Name]))
RETURN
IF(ISBLANK([Prov USD]),BLANK(),
CALCULATE(
[Prov USD],
FILTER(ALL('Customer DB'),[Prov USD]>=thisCustProv)
))

 

Regards,

Ansar