Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    In that case.....Try Replacing allselected with VALUES

     

    % Agree <70 =
COUNTROWS ( FILTER ( VALUES ( Sheet1[course_code] ), [11 % Agree Col] < .7 ) )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

How are you displaying this measure? A card visual?

 

Also, are you just trying to get the distinct number of codes? In which case you might want to use the DISTINCTCOUNT function

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Parker, distictcount doesnt seem to want to work either. Not at all sure why.