Show Matrix Total as count when values are text

[Richard_Halsall]

Hi 

After some help please

I have a fact table linked to a date table for which I have created the matrix below

The value field is text with summarization of 'First'

I would like the total field to be a count where the technician name is not No Technician i.e. for both 22/05/2024 & 23/05/2024 this would be 2

The sample data for the fact table would be, the date table is a standard date table

AllocatedDate	Team	Role	TechnicianName
22/05/2024	Team 1	Blade Tech 2:1	Joel
22/05/2024	Team 1	Blade Tech 2:2	Michael
22/05/2024	Team 1	Blade Tech 2:5	No Technician
22/05/2024	Team 1	Blade Tech 3:1	No Technician
23/05/2024	Team 1	Blade Tech 2:1	Joel
23/05/2024	Team 1	Blade Tech 2:2	Michael
23/05/2024	Team 1	Blade Tech 2:5	No Technician
23/05/2024	Team 1	Blade Tech 3:1	No Technician

Is this possible

Thanks in advance

[Anonymous · Accepted solution]

Hi @Richard_Halsall 

You can create this measure and add it to the matrix to replace the original value field of First summarization. 

ValueMeasure = IF(ISINSCOPE('Table'[Role]),MAX('Table'[TechnicianName]),COUNTROWS(FILTER('Table','Table'[TechnicianName]<>"No Technician")))

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!