Custom Sort Order - Stacked bar chart

[Jairacha]

Hi, I would like to sort my data based on two parameters. I would like to sort the data by Client Names that have the most number of Project IDs associated with them as well as the highest % win ratio for these Clients (win/(win+lost)). How can i achieve this on a stacked bar chart? I've attached the sample dataset below. Thank you!!

Client Name	Project ID	Status
Sample1	1	Won
Sample2	2	Lost
Sample2	3	Pursuing
Sample2	4	Won
Sample3	5	Lost
Sample3	6	Lost
Sample4	7	Won
Sample5	8	Lost
Sample6	9	Won
Sample6	10	Pursuing
Sample7	11	Won
Sample7	12	Won
Sample7	13	Won
Sample8	14	Lost

[amitchandak]

@Jairacha , if client is on the axis, then you can add a measure in the tooltip and use that for sorting.

[Jairacha]

Hi @amitchandak , thanks so much for your suggesstion! Would you be able to guide me through what the DAX expression would look like for such a calculation (Clients with most number of Project IDs associated with them as well as the highest win%)? Appreciate the help!!