Calculations at the same table

[MiguelSaldana77]

Hi everybody
Do anybody know what I need to do calculations at the same table like this?

[d_gosbell]

If header and concept are separate columns in your data model this should work without having to do anything special. You would just put the Header and Concept on the rows of a matrix visual then right-click on a header item and choose "expand entire level".

To get the subtotals at the bottom you just have to go into the Formatting settings for the matrix and change the subtotal position setting to Bottom

[MiguelSaldana77]

Thanks @d_gosbell  but the real problem is to make the last calculation (see image )

[d_gosbell]

Sorry I did not realise there was any difference between the different dashes in that line. You could implement something like unary operators to solve this (see https://www.sqlbi.com/blog/alberto/2011/03/01/powerpivot-parent-child-and-unary-operators/)

[TomMartens]

Hey,

I'm pretty sure that this site https://www.thebiccountant.com/ will provide you the solution you are looking for.

Regards,

Tom