cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Powerbi Column help

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

1 ACCEPTED SOLUTION
Responsive Resident

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

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

If I helped you, click on the Thumbs Up to give Kudos.

2 REPLIES 2
Community Support

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

Responsive Resident

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

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

If I helped you, click on the Thumbs Up to give Kudos.