How to reference Table Visualization total in other table visualization?

Question

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 &amp; Product B) in final table visulization.Table Visulizaiton SAMPLE DATA 1&nbsp;Table VisulizaitonSAMPLE DATA 2Product AQuantity&nbsp;Product BQuantityA100&nbsp;P200B200&nbsp;Q300C300&nbsp;R400Total600&nbsp;Total900&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Final Table Visulization&nbsp;&nbsp;&nbsp;Product A600&nbsp;&nbsp;&nbsp;Product B900&nbsp;&nbsp;&nbsp;Total A+B1500&nbsp;&nbsp;

v-yulgu-msft · Accepted Answer

Hi&nbsp;Anonymous,
&nbsp;
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"
    )
)

&nbsp;
Best regards,
Yuliana Gu

Forum Discussion

How to reference Table Visualization total in other table visualization?

2 Replies

Related content

Power BI custom visual not sending Referer

Custom Visual

Visual

Table Visual not Matching Calculated Visual

export from visual table

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