Forum Discussion
Solved
Measure value spill over
Hi All, I am converting Trade value into negative. but this value is applying for all others as well. how get the result like in second table.. TP Trade = CALCULATE([TP_$],(Data[In - out]="Trad...
Thank You Pankaj
Hello Varshi288
Try this measure
TP Trade =
IF (
SELECTEDVALUE(Data[In - out]) = "Trade",
[TP_$] * -1,
0
)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Thank You Pankaj