Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count a result of a Measure

Hi there geniuses,

 

I have a measure that indicates "yes" or "no" if a salesperson has achieved their target for the month.

 

Now I would like to count the number of salespeople that have achieved their target.

 

I have tried every type of count and calculate but I am not able to get it working.  Can you please help?

 

Cheers

 

Phil

 

 

 

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    You are welcome.  It works absolutely fine.  You were missing a closing bracket after the VALUES() function.

    Hope this helps.

7 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    If Yes, No are results of a measure and not a calculated column, then try this

    =COUNTROWS(FILTER(VALUES(Data[Salesperson]),[Target Met]="Yes"))

    Hope this helps.

    If the result is not as per your expectation, then please share the link from where i can download your PBI file.