Countrows in a table with "Y"

[zoeanne7]

Hi! 

Forgive me, this is probably really easy but I'm still relatively new to DAX and have to ggogle everything... I have a table with columns Jun - Mar (rows are staff members) with "Y" or "N" in, dependent on whether the staff member has completed a form each month. I'm struggling to find a DAX to look at the whole table and count the total number of "Y"'s without having to filter each column individually within the DAX. Can anyone advise please?

Many thanks

[tamerj1 · Accepted solution]

Hi @zoeanne7 

you need to first unpivot the table in power query. The 10 columns would be converted into one attribute column (month) and one value column (Y or N). Then a simple CONTROWS - FILTER will do. 

[zoeanne7]

Thank you so much, that has revolutionised my report!