cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
themistoklis New Contributor
New Contributor

Grand Total comes from the Subtraction of SubTotals

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.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Grand Total comes from the Subtraction of SubTotals

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
themistoklis New Contributor
New Contributor

Re: Grand Total comes from the Subtraction of SubTotals

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.