Forum Discussion
Solved
Counting Rows based on certain conditions and grouping
Hi all, I'm trying to do a 'countifs' type calc. Essentially I have a list of assignment groups with multiple appearances within one column, and an 'Achieved' or 'Breached' status (as seen b...
You could remove the FORMAT function above. Better to learn DAX basics before going ahead.
You may refer to the following DAX that creates a new table.
Table =
SUMMARIZE (
Table1,
Table1[Assg Group],
"Achieved %", FORMAT (
COUNTROWS ( FILTER ( Table1, Table1[Status] = "Achieved" ) )
/ COUNTROWS ( Table1 ),
"Percent"
)
)
Hey v-chuncz-msft,
Worked a treat!! Thanks :) Only issue is the resulting percentages are showing as txt and I cannot convert them to a numberical %.
I was hoping to filter these SLA's by priorities 1-4 as each row has an assigned priority status. However, the SLA priorities are listed on the original SLA table (table1).
Cheers,
Mike
You could remove the FORMAT function above. Better to learn DAX basics before going ahead.