Measure that only takes the selected value in a row on the matrix

[masplin]

I have a set of data like this

I want ot work out the calacuation for al lthe others in peer group vs each user i.e. see how well they are doing against their peers (peers have same job).

So for example if i filter out Susan Chohan the restt he calcuation is 0.34

I wrote this measure which works perfectly if I only have susan selected

AVG Calls per Hour In/ User UserJob Peer = 
VAR
Job=TOPN(1,VALUES(CallParticipants[UserRole]),[Call Duration (min)])
RETURN
CALCULATE(  
                                                [AVG Calls per Hour In / User],
                                                EXCEPT(ALL(PhoneUser[Name]), ALLSELECTED(PhoneUser[Name])),
                                                CallParticipants[UserRole]=jOB
                                                )
                                         

However what I would really like is to list all of the users and have it calcuate for each row excluding just the name on that row.  If I try this with my formula the answer is blank. Presumably ALLSELECTED takes all the names in the Matrix so the EXCEPT removes all of them and end up with nothing. 

If this possible so the EXCEPT clause is something like

EXCEPT(ALL(PhoneUser[Name], "SelectedonCurrentRow" (PhoneUser[Name]))

I tried SELECTEDVALUE but can't see how to make that work. Thanks for any advice

Mike

[v-jayw-msft · Accepted solution]

Hi @masplin ,

Please try

Measure = CALCULATE(AVERAGE('Table'[value]),FILTER(ALL('Table'),'Table'[name]<>SELECTEDVALUE('Table'[name])))

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.