Forum Discussion
Simple IF testing on 0 & 1
Hello Power BI Community,
this question could seem a little dumd, but the fact that IF fucntion requires a function as a testing TRUE/FALSE has blocked me several times. In excel it is easy since you test each cells.
The case I have is very simple, I have in a column for each rows either 0 or 1.
So IF(C1=0; True ; false) IF(C2=0; True; false) IF(C3=1 ; True; flase) IF(,........) I need to test each rows and for this I need a function. I was thinking of a formula to test the MAXX number of each Rows but didn't get to that, Value doesnt works since we musst jave unic values,...
This simple condition testing should be easy but its not and I've been facing this matter more than once.
Thank you for you help :-)
Regards
Mark Lovejoy
Hi Anonymous,
From your description, could you mean to judge each row in a column? If so, you could refer to below formula:
T/F = IF([Test]=0,TRUE(),FALSE())
Result:
Regards,
Daniel He
Hi Anonymous,
You could refer to below measure:
Measure = IF(CALCULATE(SUM(Table1[Number]))=0,TRUE(),FALSE())
Result:
Hope it could help you.
Regards,
Daniel He
Hello Daniel,
well the objective was not to create new data, so no I a DAX mesure is requirered and not a column formula.
I got to this solution: IF(SUMX( table, Column name = 1 ; Result if true,; resulat if false)
SUMX is an iterating function that is checking row after row informations.
Thanks for your help.
Mark
6 Replies
Hi Anonymous,
From your description, could you mean to judge each row in a column? If so, you could refer to below formula:
T/F = IF([Test]=0,TRUE(),FALSE())
Result:
Regards,
Daniel He
Hi Anonymous,
You could refer to below measure:
Measure = IF(CALCULATE(SUM(Table1[Number]))=0,TRUE(),FALSE())
Result:
Hope it could help you.
Regards,
Daniel He
Hi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hello Daniel,
well the objective was not to create new data, so no I a DAX mesure is requirered and not a column formula.
I got to this solution: IF(SUMX( table, Column name = 1 ; Result if true,; resulat if false)
SUMX is an iterating function that is checking row after row informations.
Thanks for your help.
Mark