Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF statement acting inconsistent, no FALSE option allowed

Hi all! I've got a problem with an if statement that I can't seem to figure out. To make things worse, microsofts own documentation isn't consistent with the behavior of my if statement. Here is th...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I also had a similar issue when I was using Direct query mode. 

     

    Try the following - 

     

    Category1CountWeek =
    SUMX(
    VALUES('VBM+Server'[Serial number])
    , IF(([ProductionCategoryWeek] = "0 - 50"), (1),(0)))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I also had a similar issue when I was using Direct query mode. 

 

Try the following - 

 

Category1CountWeek =
SUMX(
VALUES('VBM+Server'[Serial number])
, IF(([ProductionCategoryWeek] = "0 - 50"), (1),(0)))
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a lot, that worked! I guess everything might need to be in () cause the logical statement is also in ()