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, ...
Need Help
PC2790's avatar
PC2790
Icon for Community Champion rankCommunity 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?