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 )
)% Agree <70 =
COUNTROWS (
FILTER ( ALLSELECTED ( Sheet1[course_code] ), [11 % Agree Col] < .7 )
)
Hi Zubair_Mohamad, this is bringing back the overall result of the number of course codes <.7. It breaks when I try to use the measure to show results by category in a table. I cant seem to work in the categories, for example the simple MED example above. Do you know how I work other filters into this? Seems like we are part of the way there.
Thanks
Keelin
- Zubair_Muhammad
Anonymous
In that case.....Try Replacing allselected with VALUES
% Agree <70 = COUNTROWS ( FILTER ( VALUES ( Sheet1[course_code] ), [11 % Agree Col] < .7 ) )
Zubair_Muhammad you're a rock star!
Thanks so much for this, it worked. I'll be able to deliver the report on time now. Thanks again