cancel
Showing results for
Did you mean:
Highlighted
New Member

## Need Help in building dax formula

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: Need Help in building dax formula

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

2 REPLIES 2
Highlighted

## Re: Need Help in building dax formula

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

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
Microsoft

## Re: Need Help in building dax formula

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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors