Forum Discussion
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, ...
v-yalanwu-msft
Community Support
Community SupportHi, 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.
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