Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!
Solved! Go to 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"))
)
@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"))
)