How to Calculate Percentage Between Two Variables in Same Column?

[Dubu44]

I'm wondering how I can calculate the percentage of one value within another value, when they're both in the same column?

For example, if I want to find out the percentage of 3rd Pty_Ind_other within Ind_other_total?

Thanks in advance!

[amitchandak · Accepted solution]

@Dubu44 , You can create a measure like

Divide(

calculate(count(Table[Variable Desc]), filter(Table, Table[Variable Desc] = "3rd Pty_Ind_other")) ,

calculate(count(Table[Variable Desc]), filter(Table, Table[Variable Desc] = "Ind_other_total"))

)