Forum Discussion
CALCULATE With ALLEXCEPT While using slicers
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
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
3 Replies
- bhanu_gautam
Super User
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
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
