Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to reference Table Visualization total in other table visualization?

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...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thank you so much Yuliana.