Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Got an issue while connecting two Tables A and B, the table and outputs are as shown below,
Table A
Table B
Expected Output
But the output I got while connecting two table is as shown below
Kindly help to resolve the issue
Thanks & Regards,
Jen
Solved! Go to Solution.
Hi @jenani_user ,
I created a sample pbix file(see the attachment), please find the details in it.
Table = UNION ( VALUES ( 'A'[NAME] ), VALUES ( 'B'[NAME] ) )
NTarget =
CALCULATE (
SUM ( 'A'[TARGET] ),
FILTER ( 'A', 'A'[NAME] = SELECTEDVALUE ( 'Table'[NAME] ) )
)
NAmount =
CALCULATE (
SUM ( 'B'[AMOUNT] ),
FILTER ( 'B', 'B'[NAME] = SELECTEDVALUE ( 'Table'[NAME] ) )
)
Best Regards
Hi @jenani_user ,
I created a sample pbix file(see the attachment), please find the details in it.
Table = UNION ( VALUES ( 'A'[NAME] ), VALUES ( 'B'[NAME] ) )
NTarget =
CALCULATE (
SUM ( 'A'[TARGET] ),
FILTER ( 'A', 'A'[NAME] = SELECTEDVALUE ( 'Table'[NAME] ) )
)
NAmount =
CALCULATE (
SUM ( 'B'[AMOUNT] ),
FILTER ( 'B', 'B'[NAME] = SELECTEDVALUE ( 'Table'[NAME] ) )
)
Best Regards