Forum Discussion
Calculate and filter not working
Hello All, I am running some survey stats and have a simple aggregate measure. I am looking to calculate the number of codes in the dataset which have less than 70% respondent agreement. I am us...
Anonymous
In that case.....Try Replacing allselected with VALUES
% Agree <70 = COUNTROWS ( FILTER ( VALUES ( Sheet1[course_code] ), [11 % Agree Col] < .7 ) )
Zubair_Muhammad
Community Champion
Community ChampionAnonymous
Give this a shot
% Agree <70 =
COUNTROWS (
FILTER ( ALLSELECTED ( Sheet1[course_code] ), [11 % Agree Col] < .7 )
)Zubair_Muhammadis a good solution. The alternate is there:
% Agree <70 = CALCULATE( COUNTROWS(Sheet1), ALLSELECTED(Sheet1) [11 % Agree Col] < 0.7 )
I am a big proponant of avoiding mixing Filter and Calculate together unless absolutely necessary. 99% of the time adding filter to calculate is redundant.