Count all rows per country.

[StuartSmith]

How can I create a measure that will display in a table visual the number of rows per "Country", similar to the below?

Thanks in advance.

[PhilipTreacy · Accepted solution]

Hi @StuartSmith 

Download PBIX file with the example below

Try this

Measure = CALCULATE(COUNTROWS('DataTable'), FILTER(ALL('DataTable'),'DataTable'[Country] = SELECTEDVALUE('DataTable'[Country])))

Regards

Phil

[StuartSmith]

Awesome & Thanks