Calculate Percentage using DAX

[Anonymous]

I have one table which has two columns- Country, Vaccine Dose Completed(values are 1st, 2nd Dose) and I want to create DAX which will show"Fully Vaccinated" by country and "% Fully Vaccinated"

I am tracking vaccination status in one of column called 'vaccination dose completed' having values- 1st dose, 2nd Dose 
Please assist at earliest. I was able to show "Fully vaccinated" column by filtering the column "vaccination dose completed" but not able to create "% fully Vaccinated" country vise

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Test the below measure:

Fully Vaccinated = CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Country]=MAX('Table'[Country])&&'Table'[Vaccine Dose Completed]="2"))

by country and "% Fully Vaccinated =  DIVIDE([Fully Vaccinated],CALCULATE(DISTINCTCOUNT('Table'[Country]),ALL('Table')),4)

Base data:

Output result:

Did I answer your question? Mark my post as a solution!If not ,could you pls share your sample data, and exepct output.

Best Regards

Lucien

[amitchandak]

@Anonymous , for % fully vaccinated, we need an idea about the population. So do you have that number?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.