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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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?