Forum Discussion

mahsan_ojaghian's avatar
mahsan_ojaghian
Icon for Helper I rankHelper I
4 years ago
Solved

create a measure that converts negative values to zero

Hi Guys. I'm really Confused!!! I have a table like this: ITEM_CODE NEED INVENTORY_QTY MISS_0 ITM_1 100 50 50 ITM_2 200 10 190 ITM_3 35 100 -65 I want to create a mea...
Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    4 years ago

    Hi  mahsan_ojaghian ,

     

    Try the following measure:

    Only Positive = SUMX( FILTER(Table, Table[Miss_0] > 0), Table[Miss_0])
MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi  mahsan_ojaghian ,

 

Try the following measure:

Only Positive = SUMX( FILTER(Table, Table[Miss_0] > 0), Table[Miss_0])