Forum Discussion

jenani_user's avatar
jenani_user
Frequent Visitor
3 years ago
Solved

Connect two table with date and common field

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 ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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