Wrong Cummulative

[Anonymous]

I want to get the cumulative total of Stock Days as per the FirstOutExpiryRank sequence.

But, as you can see Cumm Total is showing 53.24 instead of 32.96703. Please help me to fix it.

You can download sample pbix file. Thank you

DOWNLOAD 

[Fowmy · Accepted solution]

@Anonymous 

You modified formula as follows:

Cumm Total = 
var __id = MAX(SummarizedCurrentHOStock[Product Code]) 
var _rank = MAX(SummarizedCurrentHOStock[FirstOutExpiryRank])
return
IF( HASONEVALUE(SummarizedCurrentHOStock[Product Code]),  
    SUMX(
        FILTER(
             ALLSELECTED(SummarizedCurrentHOStock),
              SummarizedCurrentHOStock[Product Code] = __id &&
            SummarizedCurrentHOStock[FirstOutExpiryRank] <= _rank
        ),
        [Stock Days]
    )
)

[Anonymous]

thank you  @Fowmy