Selected vs other

[usmanrafiq]

Hi, 

I am showing this chart for selected user (page level filter on User ID) 

It shows time spend byselected user by modules 

how i can i add another blue with each blue bar for showing other users average time for module

I have User ID, Module ID and time spent in table

[v-eachen-msft · Accepted solution]

Hi @usmanrafiq ,

You could refer to the following measure:

Measure =
CALCULATE (
    AVERAGE ( 'Table'[time spent] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Module ID] ),
        'Table'[User ID] <> SELECTEDVALUE ( 'Table'[User ID] )
    )
)

[lbendlin]

create another measure that calculates the average across all users, and add it to the values part of the clustered bar chart.

[usmanrafiq]

Thanks for the reply,

How can calculate average across all users 

Or 

Calculate average across all users eccept selected one