Create count or Max column on table

[JulienV]

Hello,

I have a table with the following data (in black below)

I am trying to add a calculated Column or Measure to create a new column "AnyoneCompletedInGroup" (in red below)

in That column ,it shows true, if anyone in a given group has "Completed" = True

Attendee	Group	Completed	AnyoneCompletedInGroup
1	G1	True	True
2	G1	False	True
3	G1	True	True
4	G2	False	False
5	G2	False	False

So in example above, it shows true for all G1 record since two people have completed it. but since no one in G2 completed it shows false.

What would be the DAX to generate that column (or measure)

Thank you for your help

[Pragati11]

Hi @JulienV,

I have considered the following data:

Now I created a measure to count number of TRUEs in completed column:

No of TRUE by Group =

var t1 = CALCULATE(COUNT(Attendee[Attendee]),

FILTER(ALL(Attendee), Attendee[Completed] = "True" &&

SUMX(

FILTER((Attendee), EARLIER( Attendee[Group]) = Attendee[Group]), Attendee[Attendee] )

)

)

RETURN

IF(t1 > 0, t1, 0)

Then I just check this calculation at GROUP level and it looks right:

Now I create a second measure for the required output.

AnyoneCompletedInGroup =

IF(

[No of TRUE by Group] > 0, "True", "False"

)

Now move this to a table visual to check:

This is the expected result as per your query.

Thanks,

Pragati