Need Help in building dax formula

[PavanSateesh]

Hello Fellas,

Could you please help me in building Dax formula for identifiying No of meetings conducted with full attendance in my data set.

I am blank here as to how can i do this... My data set has only 3 columns first being the Meeting ID and Employee ID and Attendance.

If all the employees attendance is Y for a set meeting ID then my count is 1 like wise i need to do this for the huge set of rows

Regards,

Pavan S

[v-huizhn-msft · Accepted solution]

Hi @PavanSateesh,

Based on my understanding, please create a calculated column using the formula.

Flag =
IF (
    CALCULATE ( COUNT ( Table[MeetingID] ), ALLEXCEPT ( Table, Table[MeetingID] ) )
        = CALCULATE (
            COUNT ( Table[MeetingID] ),
            FILTER ( ALLEXCEPT ( Table, Table[MeetingID] ), Table[Attendance] = "Y" )
        ),
    1,
    0
)

If the Flag is 1, it means the Meeting is full attendance. So you can create a slicer including Flag, a table visual including all Meeting IDs, when you select 1 in slicer, you will get all the No of Meetings with full attendance.

Best Regards,
Angelia

[MattAllington]

There are many ways.  Assuming you load this table into the datamodel and call it Data, you could write this

=
SUMX (
    VALUES ( Data[Meeting] ),
    CALCULATE (
        IF (
            CALCULATE ( COUNTROWS ( Data), Data[Attendance] = "Y" )
                = COUNTROWS ( Data),
            1,
            0
        )
    )
)