Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

COUNT if column=100%

Hello,

 

I am trying to count the number of values = 100% in one column (Taux d'AR). I tried 

COUNTX(FILTER('Tracking FSCA 2022',[Taux d'AR]=1),'Mesures AR 2022'[Taux d'AR])

But it doesn't work, it doesn't give the right result, it should be 72 and it gives 303 (even though the number of lines total is 125).

I tried several formulas but nothing works. 

The column taux d'AR is in purcentage.

Can anyone help me?

Need Help

7 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    Hey Anonymous ,

     

    Can you provide the sample data as from the formula that you have shared, doesn't look like the complete information is available.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello,

      I still can't make any formula work. Can anybody help me????

      I have tried creating a calculated column with If Rate=100% then write OK but it does'nt work because there are duplicates of the names.

      I have tried other technics including:

      NB AR 100% = CALCULATE(DISTINCTCOUNT('Tracking FSCA 2022'[Nom1]),FILTER('Mesures AR 2022',[Nb AR reçus]=[Nb dossiers]))
      Or NB AR 100% = CALCULATE(DISTINCTCOUNT('Tracking FSCA 2022'[Nom1]),FILTER('Mesures AR 2022',[Taux d'AR]=1))
      But it doesn't actually filter It gives the total number of lines without duplicates 

       

      I'm really loosing my mind here, does anyone know how to help me? Does anyone know how to filter a measure, or transform a measure into a column so I can then filter it as a column?

       

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I doubt [Taux d'AR] is a column , it is measure, then you need the column of the above visual and filter based on a group by

     

    COUNTX(FILTER(values('Tracking FSCA 2022'[Column]]) ,[Taux d'AR]=1),'Mesures AR 2022'[Taux d'AR])

     

    measure can only filtered with row context

     

    more than one column

    COUNTX(FILTER(Summarize('Tracking FSCA 2022',[Column],'Tracking FSCA 2022'[Column2] , "_1" ,[Taux d'AR]) , [_1]=1),[_1])

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello,

      Thank you for your help

      Indeed, it's not a column it's a measure sorry. It is in form of column because I added the names so I have the rate of AR (taux d'AR) by name (but I also wanted it as a total which is why I calculated as a measure.)

      I don't understand what you put, I tried the formulas but it doesn't work. The VALUES founction would get every value of the measure? 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, Anonymous ;

    Try it .

    COUNTX(FILTER(All('Tracking FSCA 2022'),[Taux d'AR]=1),'Mesures AR 2022'[Taux d'AR])

    Or

    COUNTROWS(FILTER('Tracking FSCA 2022',[Taux d'AR]=1))

    If not right, can you provide a detailed simple example after removing sensitive information? I cannot retest the information you gave.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.