COUNT if column=100%

[Anonymous]

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?

[v-yalanwu-msft]

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.

[Anonymous]

Hello @v-yalanwu-msft, 

Thank you for your help, but it still doesn't work, it gives a result but not the right one (it counts all the lines without filtering). I exported a CVS file from the Power BI, I hope that it's enough. 

https://docs.google.com/spreadsheets/d/1be2AhPHxRnT95hGkaPJyFfwFGlZoEMJO6QPJNW5gQYg/edit?usp=sharing

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[amitchandak]

@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]

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? 

[PC2790]

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]

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?