Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF(ISBLANK(

Hi,   At first i had a simple divide to work out the % of cosistency ([Number of Consistent]/[Num Overscore]) however it wasnt accurate for ones that have 0% so i used an if formula if([Number of C...
Need Help
Tips and Tricks
  • AnthonyTilley's avatar
    AnthonyTilley
    7 years ago

    If your problem is a divide by zero issue the use divide function instead of "/"

    instead of [Number of Consistent]/[Num Overscore] use 

    measure = DIVIDE([Number of Consistent],[Num Overscore],0) this will handle divide by zero issues

    if you want to replace a value of 0% with a new value then use 

    Measure =

    var d = DIVIDE([Number of Consistent],[Num Overscore],0)

    var ret = if(d = 0,
    blank(),
    d)
    Return ret
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Instead of a/b, use DIVIDE() in dax. Here , you can pass alternate value.
https://docs.microsoft.com/en-us/dax/divide-function-dax


In order to deal with blank values, use blank() with IF().

Do some workaround, It will easily solve your existing DAX calculation.

 

Thanks,
Amit