Forum Discussion

Varshi288's avatar
Varshi288
Icon for Resolver II rankResolver II
1 year ago
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...
Need Help
Tips and Tricks
  • Varshi288's avatar
    Varshi288
    1 year ago

    Thank You  Pankaj

pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
1 year ago

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.

  • Varshi288's avatar
    Varshi288
    Icon for Resolver II rankResolver II
    1 year ago

    Thank You  Pankaj