Forum Discussion
Varshi288
Resolver II
Resolver IIMeasure 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]="Trade"))*-1
| Data | Wrong | |
| IN-Out | TP_$ | TP Trade |
| IN | 256 | -50 |
| Out | 522 | -50 |
| Trade | 50 | -50 |
| Data | Correct | |
| IN-Out | TP_$ | TP Trade |
| IN | 256 | 0 |
| Out | 522 | 0 |
| Trade | 50 | -50 |
Thanks in advance.
Thank You Pankaj
2 Replies
- pankajnamekar25
Super User
Hello Varshi288
Try this measure
TP Trade =
IF (
SELECTEDVALUE(Data[In - out]) = "Trade",
[TP_$] * -1,
0
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Varshi288Thank You Pankaj
