Skip to main content
cancel
Showing results for 
Search instead 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

Reply
mdomin35
New Member

Powerbi Column help

mdomin35_0-1717519104117.png

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
fahadqadir3
Responsive Resident
Responsive Resident

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

Sum.jpg

 

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.

View solution in original post

2 REPLIES 2
v-jianpeng-msft
Community Support
Community Support

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
Responsive Resident
Responsive Resident

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

Sum.jpg

 

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.