Calculating Percentage

[DataAnalyst13]

Hi Everyone,

I'm trying to calculate a percentage. My column consists of YES, NO and NA. What i want to calculate is just NO/(YES + NO).

How can i do this in PowerBI?

Thank you!

[truptis · Accepted solution]

Hi @DataAnalyst13 , Try this:

Result =  var count_of_NO = Calculate(count([columnname]), FILTER(tablename, [columnname]="NO"))

var count_of_YES = Calculate(count([columnname]), FILTER(tablename, [columnname]="YES"))
var total =count_of_NO + count_of_YES

RETURN
DIVIDE(count_of_NO, total)

If you wish to include NA too in the toal then you can use this:
var total = count([columnname])

@DataAnalyst13 -> Please hit the thumbs up & mark it as a solution if it helps you. Thank you.

[amitchandak]

@DataAnalyst13 ,

divide(calculate(count(Table[column]), filter(Table, Table[flag] in {"Yes", "No"})) ,
calculate(count(Table[column]), filter(allselected(Table), Table[flag] in {"Yes", "No"})) )