Forum Discussion

Dubu44's avatar
Dubu44
New Member
3 years ago
Solved

How to Calculate Percentage Between Two Variables in Same Column?

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 wi...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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"))

    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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"))

)