I want to calculate what the value is for all advisers over previous 3 months to use as a KPI
% Call/Available High =
CALCULATE([AVG % Call/Available], DATESINPERIOD('Date'[Date],MaxDate,-3,MONTH),ALLSELECTED(AdviserRole[AdviserId]))
I have tried numerous versions of ALL and al lproduce the same result
I have the date slicer as 1/9 to 18/9 so the datesin period is working as for each adviser it is calculating last 3 months. However I'm trying to get each row to show 47% which is the average over everyone selected. I've tried ALL(AdviserRole)
I've done this in the past and just can't figure why this doens't just work?