CALCULATE With ALLEXCEPT While using slicers

[Johnny_Sawdust]

I'm using the following measure:

Goal:=Calculate(Percentile.Inc([Score], 0.8), AllExcept(TalNm, TblNm[Metric]))

When I add a slicer for Employee and filter, I want the Goal to change.  But it remains the same.  

FYI, I'm using Power Pivot.  

Help please.  

Thx, John

[bhanu_gautam · Accepted solution]

Hi @Johnny_Sawdust , try using below method

Goal :=
CALCULATE (
Percentile.Inc ( [Score], 0.8 ),
ALLEXCEPT ( TalNm, TalNm[Employee] )
)

Please accept as solution and give kudos if it helps

[Johnny_Sawdust]

Hi @bhanu_gautam that is the same measure that I am using currently.  

[bhanu_gautam]

In measure you are using metric column, but you should use employee column with which you want to filter that is the one thing which I have changed