Forum Discussion

ask4atish's avatar
ask4atish
Advocate III
6 years ago

Summarize three table fields in one table

Hi, I want to create a table visual where data is coming from three different tables which are linked with each other on a key.  Table 1:   Sourceno amount A1 12 A2 85 A3 61 ...
Need Help
Tips and Tricks
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to create a calculated table as below:

Table =
UNION (
    SELECTCOLUMNS (
        'Table 2',
        "customer/vendor", 'Table 2'[customername],
        "Amount", RELATED ( 'Table 1'[amount] )
    ),
    SELECTCOLUMNS (
        'Table 3',
        "customer/vendor", 'Table 3'[vendor],
        "Amount", RELATED ( 'Table 1'[amount] )
    )
)

The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

 

Best Regards,

Giotto