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.
Hello lenawr,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
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.