Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help finding a DAX formula to use for counting

I need to find a formula to help me count some deliveries and do not know what to use. So basically my logic needs to show  if payment is >750 then 1, if payment is =0 then 0, if payment is <0 then ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    Assume that your payment column is already calculated.

    You can create a measure using the following dax:

    Measure = IF(SELECTEDVALUE('Table'[payment])>750,1,IF(SELECTEDVALUE('Table'[payment])<0,-1,0))

     

    Or as KMcCarthy9  says you can create a calculated column.

    Column = IF('Table'[payment]>750,1,IF('Table'[payment]<0,-1,0))

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

KMcCarthy9's avatar
KMcCarthy9
Icon for Helper V rankHelper V
2 years ago

You need a calculated column:
Payment = 
IF([payment] > 750, 1,
IF([payment] = 0, 0,
IF([payment] <0, -1,
0)))

Of course with this you will miss anything between 1 - 750....