Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
Need your help please.
I have two tables - Master Table and Target table:
Master Table:
Target table:
Now in Target table I want to calculate Target Column as:
Target Coumn= Efficiency benefit - 'Master Table'[Cost Avoidance]- 'Master Table'[Loss].
And the I can present the Target table in a matrix.
I have tried creating DAX using SUM and Related functions but it doesn't help.
SUM summarizes and returns one value whereas Related did not work at all.
Please anyone can help me here ?
Solved! Go to Solution.
@Saswa_D use this:
SUMX (
RELATEDTABLE ( 'Master Table' ),
Master Table'[Cost Avoidance]- 'Master Table'[Loss]
)
@Saswa_D use this:
SUMX (
RELATEDTABLE ( 'Master Table' ),
Master Table'[Cost Avoidance]- 'Master Table'[Loss]
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.