Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cumulative Sum except specific ID

Hi, I have two table in power bi, Table 1 Table 2 I am calculating the cumulative sum of amount from table, on 23-Nov-2023 the sum of Amount is 83974 with ID[1,2,3,4] but the sum of I...
Need Help
Tips and Tricks
Tutorial Requests
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

All DAX measures are in the pbix file, and I hope the below can provide some ideas on how to create a solution for your semantic model.

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    I have tried your measure in line graph it is showing constant value for all dates,

    on date 9/5/2023 the measure Result Sum and ID exclude value should be 7018 and and the cumulative sum should be 14053.

     

    Thanks