topic Re: CALCULATE With ALLEXCEPT While using slicers in DAX Commands and Tips

CALCULATE With ALLEXCEPT While using slicers

Johnny_Sawdust — Tue, 19 Mar 2024 16:52:24 GMT

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 — Tue, 19 Mar 2024 17:03:46 GMT

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 — Tue, 19 Mar 2024 18:04:40 GMT

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

bhanu_gautam — Wed, 20 Mar 2024 02:38:46 GMT

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