How to calculate percentage of non-blanks for cells that another field has a specific value?

[UsePowerBI]

Hello

I have the table:

CustomerName; Country;

I want to calculate the percentage of non-blank CustomerName only when Country=USA.

How can I do that?

Thanks!

[az38 · Accepted solution]

Hi @UsePowerBI 

if I understand you correct you need 

Measure = 
DIVIDE(
CALCULATE(DISTINCTCOUNT(Table[CustomerName]), ALL(Table), Table[CustomerName] <> BLANK(), Table[Country]="USA"),
CALCULATE(DISTINCTCOUNT(Table[CustomerName]), ALL(Table), Table[CustomerName] <> BLANK())
)

[UsePowerBI]

Thanks, can I ask:

1) why you put the ALL(Table)? Doesn't it apply the calculation to the whole table anyway?

2) why you put the Table[CustomerName] <> BLANK() ? I think COUNT already counts the non-blanks anyway?