Forum Discussion
Solved
filtered calculation changes the values
Hi, I have created calcualtion that is supossed to calclate % of bench and alloctaed countrywise. Now when I want to see only % of bench it calculates it as 100%. How to see filtered out bench as i...
Hi lenawr ,
Here is your solution.
The Dax Measure is as below.
Per = var current_val = sum('Table'[GGID]) Var total_Val = calculate(sum('Table'[GGID]),ALLEXCEPT('Table','Table'[Country])) return DIVIDE(current_val,total_Val,0)If this works, Accept as solution, Else let me know whats going wrong.
Hi v-ssriganesh unfortunately none of solutions worked
Hi lenawr ,
Here is your solution.
The Dax Measure is as below.
Per =
var current_val = sum('Table'[GGID])
Var total_Val = calculate(sum('Table'[GGID]),ALLEXCEPT('Table','Table'[Country]))
return
DIVIDE(current_val,total_Val,0)If this works, Accept as solution, Else let me know whats going wrong.