Making a measures to count how many times each value appears in a column then put in a mtrix

[Nudo]

Hey

So I have a matrix and I'm trying add a row for each individual item in a certain column counting how many times that value appears for that month.  I'm trying to make my matrix look like this.

	Jan 2022	Feb 2022
Individual column value1	4	5
Individual column value2	3	7

So I know I could manually make a bunch of measures counting but there's 20+ values and I wanna see if theres a way to do this without creating an individual measure manually for each of these.

[PhilipTreacy · Accepted solution]

Hi @Nudo 

Download sample PBIX file

Like this?

Please supply some sample data if this isn't what you want and my PBIX file doesn't explain how to achieve what you want.

Regards

Phil

[Nudo]

To get around my issue I stated, I've just created a second matrix that sits underneath the other one. Still a better solution than creating 20+ different measures. Thank you.

[Nudo]

That's exactly what I'm trying to do

[Nudo]

Problem is I have other values that aren't rows, cause If I put them in rows they show all their individual values which I don't want I just need the count.