cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

Count the Measure Results (Measue is Max of Column)

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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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)``

Anonymous
Not applicable

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)``