Getting the percentage of a name in a state

[Anonymous]

So I've been playing around with the USA Names dataset from BigQuery, and I've been trying to make a viz that shows the prevalence of a given name in each state (as in, the percentage of people having that name in that state over the total population of the state).

I'm still relatively new to Power BI so I still get a little confused when it comes to DAX, especially when it comes to measures like this where I get really confused when it comes to dealing with both a sum affected by a slicer and one relative to the whole table.

I wanna have a map like this, but instead of the total number of people, I'd get the percentage instead.

I tried creating a GroupBy table with the names and the states, and make the percentage a column instead, as follows, but it kept giving me weird values.

[Mariusz · Accepted solution]

Hi @Anonymous 

try Measure like this.

Measure = 
DIVIDE(
    COUNTROWS( 'Table' ),
    CALCULATE(
        COUNTROWS( 'Table' ),
        ALLEXCEPT( 'Table', 'Table'[Name] )
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Hi @Mariusz

Edit: nevermind, I misinterpreted it, you are 100% right !

[Mariusz]

Hi @Anonymous 

My dataset.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn