Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Table Student and the columns are Group and Pass.
I need to create a measure where:
if even one feild in pass is True, then the group should be TRUE else it should be a false.
I have a measure which looks like below which does not seem to give me the write result.
Measure:= if(maxa('Student'[Pass]) = 1, true(),false())
Solved! Go to Solution.
Hi @gene
You could try with this measure....
True-False = IF ( SUMX ( ADDCOLUMNS(Student;"NumPass";IF(Student[Pass];1;0)) ;[NumPass] ) >= 1 ; TRUE() ; FALSE() )
I hope it helps
Regards
BILASolution
Just another way of doing it
True-False = CALCULATE(countrows(Student),Student[Pass]=True)>=1
Hi @gene
You could try with this measure....
True-False = IF ( SUMX ( ADDCOLUMNS(Student;"NumPass";IF(Student[Pass];1;0)) ;[NumPass] ) >= 1 ; TRUE() ; FALSE() )
I hope it helps
Regards
BILASolution
Just another way of doing it
True-False = CALCULATE(countrows(Student),Student[Pass]=True)>=1
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |