dax: if count of atleast one true in a group then true

[gene]

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())

[BILASolution · Accepted 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

[BILASolution · Accepted 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

[Zubair_Muhammad · Accepted solution]

@gene

Just another way of doing it

True-False = CALCULATE(countrows(Student),Student[Pass]=True)>=1