Solved: Count the Number of Sales Rep Achievement %

ADSL · ‎10-11-2022

Hi BI Community Team,

I have the table as the screenshot below and want to count the number of sales rep achievement greater than or equal to (>= 65%).

Any suggestion of the measure? Please kindly advise.

Best Regards,

Jihwan_Kim · ‎10-11-2022

Hi,

I assume [Ach%] is a measure.

Please write a measure something like below, and put it into a card visualization whether it suits your requirement.

Expected count measure: =
COUNTROWS ( FILTER ( 'SalesRepTable', [Ach%] >= 0.65 ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎10-11-2022

Hi,

I assume [Ach%] is a measure.

Please write a measure something like below, and put it into a card visualization whether it suits your requirement.

Expected count measure: =
COUNTROWS ( FILTER ( 'SalesRepTable', [Ach%] >= 0.65 ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

ADSL · ‎10-11-2022

Thank you very much for your feedback.

Best Regards,

Count the Number of Sales Rep Achievement %