Forum Discussion

lenawr's avatar
lenawr
New Member
1 year ago
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...
  • Rupak_bi's avatar
    Rupak_bi
    1 year ago

    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.

v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

Hello lenawr,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.