Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How Get In measures

Cost = CALCULATE(SUM(A[Cost]),FILTER(A,A[Group]=B[Group]))
 
This my calculated column DAX its giving expected result, I have tried many ways to create this in Measure But I am not able to achive the result by measure.
 Table A
GroupCost
A5
A5
B4
 
Table B 
GroupCost
A10
B4
 
I want result as Table B, How I achive the above mentioned results using measure
 
 
1 ACCEPTED SOLUTION
johnt75
Super User
Super User

I think this will work

Cost = CALCULATE( SUM('A'[Cost]), TREATAS( VALUES('B'[Group]), 'A'[Group]) )

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Execellent John, Its working as expected 

johnt75
Super User
Super User

I think this will work

Cost = CALCULATE( SUM('A'[Cost]), TREATAS( VALUES('B'[Group]), 'A'[Group]) )

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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