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

Thanks Parker neither worked :(

 

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. 

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Anonymous，

       

      Please try this:

       

      % Agree <70 = CALCULATE(COUNT(Sheet1[course_code]),FILTER(ALL(Sheet1),[11 % Agree Col]<.7))

       

      If it still doesn't work, please post sample data and show us your desired output so that I can test on my side.

       

      Regards,

      Yuliana Gu

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Thanks Guys, 

         

        This didnt work. 

         

        my Data is structured like this:

         

        Respondent ID | Category | Code | Agree or Disagree

         

        e.g. 

        123455| MED | 1XY45 | Agree

        123344| MED | 1XY45 | Disagree

         

         

        I want to be able to calculate % Agreement of each code (in this case 1XY45) and then count the number of codes that have less than 70% agreement by category. 

         

        So the simple example above would give me 50% agreement for code 1XY45 and 1 survey with less than 70% agreement for the category MED

         

        I seem to be able to calcualte the % Agreement but cant seem to be able to calculate and filter on the % agree measure.

         

        Maybe I need to sumamrise the data?

         

        Thanks so much, 

        Keelin