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 within Ind_other_total?

 

 

 

Thanks in advance!

 

 

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

    )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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"))

    )