Forum Discussion
M_SBS_6
3 years agoHelper V
Subtract values from same column
Hi, Is there any calculation that I can do in a matrix table that would allow me to subtract one value in a column by another value in the same column? I have attempted to do here but the val...
Ashish_Mathur
3 years agoSuper User
Hi,
Assuming Amount is a measure that you have already written, write this measure
Measure = [Amount]-calculate([Amount],'apps'[app_cat]="YTL")
M_SBS_6
3 years agoHelper V
Thanks for your suggestion. I have tried this measure but all that seems to happen is my value for "YTL" returns a 0.
- Ashish_Mathur3 years agoSuper User
You are welcome. What happens to the INT value?
- M_SBS_63 years agoHelper V
The same value remains, 100000.
- Ashish_Mathur3 years agoSuper User
Share the download link of the PBI file.