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 connecting two table is as shown below

 

Kindly help to resolve the issue

 

Thanks & Regards,

Jen

 

 

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

1 Reply

  • 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