Count the Measure Results (Measue is Max of Column)

[Anonymous]

Hi Team,

I haven't been able to figure out to how to count measure results.

I have an Matrix. Below is what Matrix looks like with measure:

Measure = Max(Table1[column])

I put the measure in the matrix in value field.

Company Name	Measure
C1	Green
c2	Red
c3	Yellow
c4	Green

Is there way to count how many green, yello and red are there provided by measure?

I want to list them in row card next matrix to show Total Green, Red, yellow by company

I tried: 

COUNTROWS(FILTER('Table1','Table1'[Measure]="GREEN"))

but this didn't work. 

[Anonymous · Accepted solution]

I was able to solve this using three different measures for each color.

VAR col = SUMMARIZE(Table, Table[Company],"Color",[Measure]) RETURN COUNTX(FILTER(col,[Measure] = "Red"),1)