Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.