Subtract rows of same column in PowerBI

[sonaliverma]

Hello ,

As you can see, I have created a Matrix in PowerBI. I want to subtract  (010-020). 

Could anyone help me with this issue?

Thanks in advance

[selimovd · Accepted solution]

Hey @sonaliverma ,

you can create sub totals for each value with variables and then subtract them.

The following approach should work:

My Total Measure =
VAR v010Value =
    CALCULATE (
        SUM ( myTable[myValue] ),
        myTalbe[Value Type for Reporting] = '010'
    )
VAR v020Value =
    CALCULATE (
        SUM ( myTable[myValue] ),
        myTalbe[Value Type for Reporting] = '020'
    )
RETURN
    v010Value - v020Value

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up.

Best regards
Denis

Blog: WhatTheFact.bi

[sonaliverma]

Thank you so much @selimovd , worked like a charm!

[amitchandak]

@sonaliverma , You have create a measure for that, Row operation is not possible in power bi

M1=

calculate(sum(Table[Value]), filter(Table, Table[Value Type] ="001")) -

calculate(sum(Table[Value]), filter(Table, Table[Value Type] ="002"))

using isinscope, you can show that in grand total

if(not(isinscope(Table[Value Type])) ,[M1], sum(Table[Value]))

[sonaliverma]

Thank you for your response @amitchandak