DAX query to compare previous values

[rsrajkumar]

I am new to PowerBI. I need help in creating a DAX function for the below table named 'Cases'. The requirement is to Sum the Column 'Value' that have the same 'ID'. For example the DAX expresssion should return 1 for A1B, 2 for B2C, and 1 for C2A  

[lbendlin · Accepted solution]

Have you tried putting both columns into a table visual - you should get your desired result without DAX.

[lbendlin · Accepted solution]

Have you tried putting both columns into a table visual - you should get your desired result without DAX.

[rsrajkumar]

Thanks @Ibendlin. While for this specific example the table works as mentioned by you (did not know that until now), my actual use case is complex that I would need the DAX expression. Request if you can please help me

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[rsrajkumar · Accepted solution]

@lbendlin I tried the table visual solution with additional filters, and it worked. Thanks a lot!