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.