unknown formula error

[BartUncles]

Hi,

I have something weird happening in PowerBI currently. When typing an IF statement in the Logical test you normally typ a comma and then the formula will automatically move to the ResultifTrue part of the formula, and after another comma it moves to the ResultifFalse. But as per today it is not working, i basically have to typ 2 commas to move to the next stage of the formula. 

Normally it would work like this:

if(sum(A))=1,1,0)

Now if have to do this which makes no sense. 

if(sum(A)),,1,,1,,0) 

I think it has something to do with language settings, but not sure... Everything works in Excel, and I've also tried using a ; 

Any thoughts?

[v-qiuyu-msft]

Hi @BartUncles , 

Please modify the DAX like below then test again: 

if(sum(A)=1,1,0)

Best Regards,
Qiuyun Yu