topic Dax to calculate to Met and Not Met in DAX Commands and Tips

Dax to calculate to Met and Not Met

Baks007 — Mon, 22 May 2023 03:38:00 GMT

Im trying to calculate the Met/Not Met using dax in the below format.

tamerj1 — Mon, 22 May 2023 04:02:24 GMT

please try

Met =
SUMX ( VALUES ( 'Date'[MonthYear] ), INT ( [Attendence %] >= 0.95 ) )

Not Met =
SUMX ( VALUES ( 'Date'[MonthYear] ), INT ( [Attendence %] < 0.95 ) )

Baks007 — Mon, 22 May 2023 04:38:00 GMT

Thanks tamerj1 .It worked.