How to reference Table Visualization total in other table visualization?

[Anonymous]

Hello ,

I am converting excel report into power bi report.I have multiple table visulization and matrix visulizaiton in my report.Please see below dataset and final result table.In excel we can give cell reference but here How can I give TOTAL Reference(Prodcut A & Product B) in final table visulization.

Table Visulizaiton SAMPLE DATA 1		Table Visulizaiton SAMPLE DATA 2
Product A	Quantity		Product B	Quantity
A	100		P	200
B	200		Q	300
C	300		R	400
Total	600		Total	900
	Final Table Visulization
	Product A	600
	Product B	900
	Total A+B	1500

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Based on my understanding, your data in visualization1 and visualization2 is from two different datasets, right? If so, to get the final output in Power BI desktop, you could create a calculated table like below, then, add it to table visual.

Final Product table =
UNION (
    ADDCOLUMNS (
        SUMMARIZE ( 'ProductA Table', "Quantity", SUM ( 'ProductA Table'[Quantity] ) ),
        "Product", "ProductA"
    ),
    ADDCOLUMNS (
        SUMMARIZE ( 'ProductB Table', "Quantity", SUM ( 'ProductB Table'[Quantity] ) ),
        "Product", "ProductB"
    )
)

Best regards,

Yuliana Gu

[Anonymous]

Thank you so much Yuliana.