Creating a table of column totals

[Anonymous]

Hi all, I'm trying to create a table of the column totals of a seperate table but I'm not sure what DAX/functions to use, if anyone has any suggestions then that'd be great!

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Select all columns in Power Query – Unpivot Columns.

Result：

2. Create calculated table.

Table 2 =
SUMMARIZE('Table','Table'[Attribute],"Value",SUMX(FILTER(ALL('Table'),'Table'[Attribute]=EARLIER('Table'[Attribute])),[Value]))

3. Result:

If you need pbix, please click here.

Best Regards,

Liu Yang

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

[Anonymous]

That's perfect! Thanks so much for solving this, I massively appreciate it!

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example?

I can suggest How to create a row for this UI. We usually use Remainder (using MOD) and create a column and use that
Appreciate your Kudos.

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example?

I can suggest How to create a row for this UI. We usually use Remainder (using MOD) and create a column and use that
Appreciate your Kudos.