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)))
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi Anonymous ,

 

I am not able to recreate your issue, this code works as expected in the small sample file I created for myself:

 

if_test =
SUMX (
    VALUES ( 'Table1'[Column1] ),
    IF ( ( [measure] > 5 ), 1, 0 )
)

 


Perhaps try to create a very simple model, and see if you are able to create your issue yourself. If you are, you could share the sample report

 

Cheers,
Sturla