Forum Discussion

BeastHouse's avatar
BeastHouse
Frequent Visitor
3 years ago
Solved

IF/OR Formula Help

Hi, trying to calculate an exchange rate used in a procurement data set. The below formula is throwing the error DAX comparison operations do not support comparing values of type Number with values o...
blanks
if
OR
values
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi BeastHouse 

    try like:

    Exchange Rate =
    IF(
    'Stock Orders'[Exchange Rate For Report Estimates]=0,
    1,
    'Stock Orders'[Exchange Rate For Report Estimates]
    )
     
    DAX take 0 and blank as the same.
ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

Hi,

The issue is this part of your dax:

'Stock Orders'[Exchange Rate For Report Estimates]=""

Example and solution:

This won't work:

Measure 38 = IF(MAX('Table (21)'[Column1])="",1,0)
 

This will work:

Measure 38 = IF(ISBLANK(MAX('Table (21)'[Column1])),1,0)

So in Short use ISBLANK to solve the issue.

 

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/