Rollup Rows and Table Visual

senthilvaithi — Mon, 30 Sep 2024 03:37:01 GMT

Hi, I have a table created using summarizecolumns and rollupaddissubtotal. I want to display this in a table visual. I want the rolled up row to appear as the total row in the visual. I am able to put this easily into a table visual, but the total row appears as a normal row. How to I tell the table visual, that a particular row needs to be treated as the total row?

Can you help, your efforts are highly appreciated.

Re: Rollup Rows and Table Visual

Anonymous — Tue, 01 Oct 2024 02:46:51 GMT

Hi @senthilvaithi ,

According to your statement, I think you currently create a calculated table by SUMMARIZECOLUMNS() and use ROLLUPADDISSUBTOTAL() to add rows as subtotal in your calculated table.

Your requirement should be that show subtotals by group like the result in your calculated table.

As far as I know, Table visual support us show result based on row or column.

You can try matrix and add your groups in Row or Column Fields, than Power BI will show result by group ( in hierarchy level).

For reference:Create a matrix visual in Power BI - Power BI | Microsoft Learn

You don't need to create a calculated table, you can use columns from tables in matrix directly (different tables need to be related by columns).

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Rollup Rows and Table Visual in Developer

Rollup Rows and Table Visual

Re: Rollup Rows and Table Visual