Grand Total comes from the Subtraction of SubTotals

[themistoklis]

Hello All,

I have a matrix and using one measure I show 3 entities (Income, Income 2 and Expenses).

Each one of the entities has a list of other sub-entities thus i used a matrix.

What i am trying to do is, for the Grand Total row only to get the sum of the subtotals from Income and Income 2 and subtract the value from Expense Subtotal.

I cannot do it now because all values on this metrics are positive.

Any ideas on how to deal with this without creating negative values for the expenses entity.

[v-shex-msft]

Hi @themistoklis ,

Please share some sample data to help us clarify your requirement.

How to Get Your Question Answered Quickly

In addition, you can also take a look at following link about measure total calculation:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng

[themistoklis]

Hello @v-shex-msft ,

I found this post in the community which describes the technical part of what im trying to achieve.

It seems that it is something that still cannot be done on PowerBI.