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"))
)
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |