General Mesure

[Ily]

Hello guys,

I have a question  , how to make a general mesure :

ID_CLIENT PART 

1                     15%

2                      20%

3                     30%

I wanna make the average of the  column part for all clients  whatever the filter  is on the client 

I wanna make it on the visualisation

Thank you so much

[edwin]

in your expression add set analysis to ignore the selected client (or client id)

for example

sum({<[Client ID]=>} something)

this tells the expression to calculate for all client IDs regardless of what was selected