Forum Discussion

glynwilks's avatar
glynwilks
Helper I
3 years ago
Solved

Count Top N

Hello, I  am using dyamic text to display the following.

 

The below also shows that <Top Agent> has received the most positive responses from end users with a total of <Total Positive Responses> positive responses.

 

I can calculate top 1 agent with most positive feedback as 

Top Rated Agent = TOPN(1,ALLNOBLANKROW(Smileback[ticket.agents]),[Total SmileBack Reviews]) and this works. But for the second part, I need to calculate the total number of positive responses for the returned agent. How can I calculate the number of Top N results as per above?
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi glynwilks 
    To achieve a goal I created 3 measures:

    1. Counter of positive responses :

    PositiveCount =
    CALCULATE(
        COUNTROWS('table'),
        'Table'[Rating Name] = "Positive"
    )
    2. Top 1 for aggent :
    Top agent =
    TOPN(1,
        ALL('table'[Agent]),
        [PositiveCount],
        DESC)
    3. "Filtered" counter that you can put on your text:
    Top1PositiveCount =
    CALCULATE(
        [PositiveCount],  -- Your previously created PositiveCount measure
        TOPN(1, ALL('table'[Agent]), [PositiveCount], DESC)
    )
    + Text measure :
    Top agent text = "Top agent is " & [Top agent] & "He has " & [Top1PositiveCount] & " positive responses"
    Result :

8 Replies