Get total count of each distinct value

[Anonymous]

Hi all,

If I for example have a column of countries that might repeat and the list follows like this: Spain, Spain, Italy, Spain

I want to get the result that I take the number that a country appears in the column and divide it by total number. I have tried: 

CountRows = DIVIDE(DISTINCTCOUNT('Report (7)'[Country]); COUNT('Report (7)'[Country]) )

Any suggestions? do I need a new column for that?

[AlB · Accepted solution]

Hi @Anonymous 

1. Place 'Report (7)'[Country] in a table visual

2. Place this measure in the visual

CountRows =
DIVIDE (
    COUNT ( 'Report (7)'[Country] );
    CALCULATE ( COUNT ( 'Report (7)'[Country] ); ALL ( 'Report (7)'[Country] ) )
)

That will give you a table with the number you're looking for, per country

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers