Count rows for multiple columns

Hi DarSz ,

In Power Query, you'll want to unpivot your class columns.

Select your [id] column, then on the Transform tab choose Unpivot Columns dropdown and select Unpivot Other Columns.

This should get you something like this:

Then your measures only need to reference the [class] (attribute) column and the [status] (Value) column.

You could then create a simple measure as follows:

_noofValues = COUNTROWS(yourTable)

You can then use this measure in a matrix to show the intersect count of class vs status, something like this:

Pete