Powerbi Column help

[mdomin35]

I am trying to Sum the value of AC by each date, and filter with 2 Accounts (AN) labeled as 8000 & 2500, how would I do that?

Like for date 12-29-2022, I want to have the sum of AC by both account number 8000 and by account number 2500

Example: on date 12-29-2022 AC=1,000,000 for AN 8000, and AC=2,000,000 for AN 2500

[Anonymous]

Your solutions is great @fahadqadir3 

Hi, @mdomin35 

Have you already solved the current problem? If yes, you can share your solution here or mark your helpful reply as a solution so that other members of the community can quickly find a solution if they encounter the same problem. Thank you very much for your cooperation.

Best Regards

Jianpeng Li

[fahadqadir3 · Accepted solution]

@mdomin35 Review the following screenshot and Measure to Calculate Total:

Total SUM of 2500&8000 = 
CALCULATE(
 SUM('Table'[AC]),
    'Table'[AN] IN {8000, 2500}
)

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.