Forum Discussion

gaurav-narchal's avatar
gaurav-narchal
Helper I
2 years ago
Solved

Measure - Greator than

Hello   I need help to create a measure as below   If the balance is greater than or equal to the Amount return TRUE or else FALSE. I tried to create a measure but did not get the desired result ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi gaurav-narchal ,

    Hi ryan_mayu , I'm guessing OP is trying to calculate the magnitude of the absolute value🤔. The expected results given by the OP are in perfect agreement with the comparison of absolute magnitudes😀.
    Just change your DAX into this:

    Column = if(ABS('Table'[Balance])>ABS('Table'[Amount]),TRUE(),FALSE())

    Anyway, good answer!

    Best Regards,
    Dino Tao

  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    gaurav-narchal 

    Pls try 

    Measure = IF(SUM('Table'[Balance])>SUM('Table'[Amount]),TRUE(),FALSE())

    or 

    Measure2 = IF(ABS(SUM('Table'[Balance]))>ABS(SUM('Table'[Amount])),TRUE(),FALSE())

rubinboer's avatar
rubinboer
Resolver II
2 years ago

hi gaurav-narchal please check your data types, are amount and balance text or numeric.