cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cham Member
Member

how to get the maximum number of calls answered persons name

Hi,

 

I want show a Card in Power BI showing maximum number of calls answered user and number of calls he answered.

Ex- I want to show B and number of calls he answered = 45

 

NUMBER OF CALLS.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: how to get the maximum number of calls answered persons name

@cham

Try this measure

 

Measure =
VAR MyName =
    CONCATENATEX ( TOPN ( 1, Table1, [Answered], DESC ), [Name], ", " )
RETURN
    "Maximum number of calls answered were " & MAX ( Table1[Answered] )
        & " which were answered by user "
        & MyName
2 REPLIES 2
Super User
Super User

Re: how to get the maximum number of calls answered persons name

@cham

Try this measure

 

Measure =
VAR MyName =
    CONCATENATEX ( TOPN ( 1, Table1, [Answered], DESC ), [Name], ", " )
RETURN
    "Maximum number of calls answered were " & MAX ( Table1[Answered] )
        & " which were answered by user "
        & MyName
cham Member
Member

Re: how to get the maximum number of calls answered persons name

Thank You so much