Compare a single client performance versus a the segment performance

[phgatto]

Hello Everyone,
I would like to find the best way to compare a client performance versus a particular segment it is part of. 
For example: When consulting a specific tour operator, it should bring the result of that specific company 
comparing with the other companies in that segment.
As the information is divided into different tables, I will share the way the data is structured:

First sheet:

Month	Hotel	Client Code	Revenue
jan/19	Hotel XYZ	435	3249
jan/19	Hotel XYZ	385128	25982
jan/19	Hotel XYZ	1594176	9355
feb/19	Hotel XYZ	435	759
feb/19	Hotel XYZ	385128	42165
feb/19	Hotel XYZ	1594176	935
mar/19	Hotel XYZ	435	0
mar/19	Hotel XYZ	385128	28037
mar/19	Hotel XYZ	1594176	955
apr/19	Hotel XYZ	435	1001
apr/19	Hotel XYZ	385128	32867
apr/19	Hotel XYZ	1594176	355
may/19	Hotel XYZ	435	2521
may/19	Hotel XYZ	385128	70034
may/19	Hotel XYZ	1594176	10355
jan/21	Hotel XYZ	435	0
jan/21	Hotel XYZ	385128	56707
jan/21	Hotel XYZ	1594176	29355
feb/21	Hotel XYZ	435	886
feb/21	Hotel XYZ	385128	49385
feb/21	Hotel XYZ	1594176	896
mar/21	Hotel XYZ	435	5684
mar/21	Hotel XYZ	385128	4364
mar/21	Hotel XYZ	1594176	27244
apr/21	Hotel XYZ	435	12972
apr/21	Hotel XYZ	385128	7633
apr/21	Hotel XYZ	1594176	244
may/21	Hotel XYZ	435	7244
may/21	Hotel XYZ	385128	9323
may/21	Hotel XYZ	1594176	724

Second Sheet:

Client Code	Client Name	Client Group	Segment	Country
1594176	John Tour	John Tour	Tour Operator	Brazil
1595257	John Tour	John Tour	Tour Operator	USA
274988	John Tour	John Tour	Tour Operator	Spain
435	Mary Tour	Mary Tour	Tour Operator	UK
385128	Terry Tour	Terry Tour	Tour Operator	Brazil

The idea is compare a single client, or the group he belongs to, versus the segment he belongs to, for example: 
Filtering by the single client John Tour (Brazil), it compares the performance of that client over the months 
against all others in the segment.
If I filter the John Tour Group (Brazil, USA and Spain) it compares the performance of this group versus
the other clients not selected from the tour operator segment.

The idea is to insert a bar graph like the one below.

I hope I've been more efficient in my explanation now. Thanks again.

[amitchandak]

@phgatto , Measure

Client rev = sum(Table[Revenue] )

Client rev Segment= calculate(sum(Table[Revenue] ), filter(allselected(Table), Table[Segment] = max(Table[Segment]) ) )

% = divide([Client rev], [Client rev Segment] )

or

% = divide([Client rev], [Client rev Segment]- [Client rev] )

[phgatto]

Good Evening @amitchandak 

Unfortunately this isn't the solution that I'm looking for.