Filter a Client and shows all Client Sales from a group

[fcarvalho]

Hi, 

I need to filter a Client and then show all sales from all clients from the same group as the selected, and I'm getting stucked with that.

Clients	Groups	Sales
Client1	XPTO	12312
Client2	ZZZZ	4324
Client4	ZZZZ	435
Client3	XPTO	2131

Example:

When I select Client1, shows the sales of Client1 and Client3, because they are from the same group (XPTO), or if I filter Client4, shows only Client4 and Client2 sales.

I need this filtering way, instead of filtering the group, because in my embedded solution i only can get the client parameter.

Client1 selected (exemple):

Shows a Bar Chart like that

Client 1 ------ 12312

Client 3 ---- 2131

[amitchandak · Accepted solution]

@fcarvalho , a measure like this

measure =
var _tab = summarize(filter('Table', 'Table'[Client] in allselected('Table'[Client])),'Table'[Groups])

return
calculate(sum(Table[Sales], filter(all(Table), Table[Groups] in _tab))

But this will work better if the client and group is an independent table

measure =
var _tab = summarize(filter('Client', 'Client'[Client] in allselected('Client'[Client])),'Client'[Groups])

return
calculate(sum(Table[Sales], filter(all(Table), Table[Groups] in _tab))