Forum Discussion
How To Subtract
- 4 years ago
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.
- 4 years ago
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.
- 3 years ago
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 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.
- Mohammadwazeri3 years agoHelper III
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.