Forum Discussion
How To Subtract
- 3 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.
- 3 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 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.
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.