Need to implement Cumulative-Running total in power BI (We are getting wrong values)

[ManojV]

• We are trying to create Cumulative running total for the data to display

• When we tried to get the values for column with running total function with below DAX function it gives the wrong value.

DAX Formula:

Distinct Unique Asset running total in AssetSize__c =

CALCULATE(

[Distinct Unique Asset],

FILTER(

ALLSELECTED('Account'[AssetSize__c]),

ISONORAFTER('Account'[AssetSize__c], MAX('Account'[AssetSize__c]), DESC)

)

)

• We have a column with name as a product name and he have different categories with repetition and we have another column name net Asset.

• So when we are trying to calculate the running total based on above formula with respect to net asset column we should get cumulative  running total.

• When we are trying to doing the same by using above formula we are not getting the expected running total.

• So we need a help to get expected results.

Thanks in Advance

[v-deddai1-msft]

Hi @ManojV ，

Would you please inform us more detailed information( your sample data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[amitchandak]

@ManojV , Formula is fine.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.