The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am looking for Conditional measure formula using 2 tables. Following sample file is attached for reference.
Can someone please provide suitable measure formula in order to calculate expected result.
Thanks in advance.
SM
Solved! Go to Solution.
Hi @mshaikh,
Firstly, you could create the relatioship with the table A and B with Key column.
Then you could create the calculated column for Table-B with the formula below.
Column = IF ( CALCULATE ( MAX ( 'Table-A'[A01-KEY] ) ) = CALCULATE ( MAX ( 'Table-B'[B01-KEY] ) ) && CALCULATE ( MAX ( 'Table-B'[B01-Type] ) ) = 99, CALCULATE ( SUM ( 'Table-A'[A01-Amount] ), FILTER ( 'Table-B', 'Table-B'[B01-KEY] = EARLIER ( 'Table-B'[B01-KEY] ) ) ), 0 )
Then you will get the output you like.
If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @mshaikh,
Firstly, you could create the relatioship with the table A and B with Key column.
Then you could create the calculated column for Table-B with the formula below.
Column = IF ( CALCULATE ( MAX ( 'Table-A'[A01-KEY] ) ) = CALCULATE ( MAX ( 'Table-B'[B01-KEY] ) ) && CALCULATE ( MAX ( 'Table-B'[B01-Type] ) ) = 99, CALCULATE ( SUM ( 'Table-A'[A01-Amount] ), FILTER ( 'Table-B', 'Table-B'[B01-KEY] = EARLIER ( 'Table-B'[B01-KEY] ) ) ), 0 )
Then you will get the output you like.
If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry