How To Subtract

[Mohammadwazeri]

Hi Guys,

Could you please help me? 

How to subtract Total USD from GRPO Total USD and then subtract the result (Remaining USD) from the second row of GRPO Total USD again subtract the result (Remaining USD) from the third row of GRPO Total USD and it should keep going all the way to the end.

It could be either in Query Editor or using DAX.

See the snapshot please.

Thank you so much in advance.

[parry2k · Accepted solution]

@Mohammadwazeri try this measure

Measure = 
SUM ( 'Table'[Total] ) - 
CALCULATE ( 
    SUM ( 'Table'[GPRO] ),
    FILTER ( 
        ALL ( 'Table' ),
        'Table'[No] <= MAX ( 'Table'[No] )
    )
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k · Accepted solution]

@Mohammadwazeri share DAX expression you are using, and make sure the index column is in the visual:

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k · Accepted solution]

@Mohammadwazeri change ALL to ALLSELECTED

Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Mohammadwazeri]

Thank you so much @parry2k! It's working now. 🙂

[parry2k · Accepted solution]

@Mohammadwazeri share DAX expression you are using, and make sure the index column is in the visual:

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Mohammadwazeri]

Hi @parry2k ,

I am sorry, I thought I already shared it with you. I found out it didn't go through due to weak connection.

In the snapshot the index and the measure you sent me.

[parry2k · Accepted solution]

@Mohammadwazeri try this measure

Measure = 
SUM ( 'Table'[Total] ) - 
CALCULATE ( 
    SUM ( 'Table'[GPRO] ),
    FILTER ( 
        ALL ( 'Table' ),
        'Table'[No] <= MAX ( 'Table'[No] )
    )
)

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Mohammadwazeri]

Hi @parry2k 

Actually there is not "No" field in the actual table, but I added and Index and tried it didn't work.

See the snapshot.