Creating a Matrix Table from Different Columns

[emman_burgonia]

Hi everyone, 

I am still pretty new in Power BI but I am having trouble creating a matrix visualization based on this table:

The idea should look like this

I was able to extract the years however I cannot add the count of codes for the columns. Can you help me figure out the possible solution for this? 

[Coriel-11 · Accepted solution]

In the "Rows" box drag the "Geocity" field

In the "Columns" box put the "EnrolementYear" field

In the "Values" box put the "Code" BUT then right click on it and choose "Count".

Apologies if that's what you've already tried. If so, perhaps you could explain a little more or provide some sample data.

[emman_burgonia]

Hi @PijushRoy 

Here's the sample data

CodeGeoCityEnrolmentYear

fr109	Rennes	2003-2004
fi016	Tampere	2019-2020
fi017	Helsinki	2021-2022
fi212	Espoo	2021-2022
fi033	Helsinki	0
fi034	Helsinki	2021-2022
fi036	Helsinki	2021-2022
fi041	Kuopio	2021-2022
bo008	Santa Cruz	2021-2022
bo008	Santa Cruz	2021-2022
bo008	Santa Cruz	2021-2022
bo008	Santa Cruz	2021-2022
at034	Vienna	2021-2022
ar103	Buenos Aires	2019-2020
ar103	Buenos Aires	2019-2020
ar103	Buenos Aires	2019-2020
ar103	Buenos Aires	2019-2020

[JorgePinho]

If you want to display the number of codes by city and year you can do this:

Add the year field to the Columns and the city field in the Rows. Then in the Values you can add DAX measure like this:

Count_of_code = COUNTROWS(Code)

[PijushRoy]

Hi @emman_burgonia 

Please share (copy and paste) sample data