sorting Customer sales by country

[Manne_DE]

I need help please - I have a data model which contains the revenues/sales by month/year and country for my customers

I would like to create a visualation which shows, which customer have revenues/sales over all/many countries, sorting decending by the customer with the biggest footprint and highest revenue.

Here you can see how I can show the data using a matrix

	Country
Customer	Belgium	UK	Netherlands	Spain	Total
Client1	100	0	0	50	150
Client2	500	250	130	50	930
Client3	0	50	0	0	50
Client4	0	10	30	0	40
Client5	20	0	0	0	20
Client6	250	100	0	0	350
Client7	1.000	0	0	0	1.000
Client8	0	20	30	40	90
Client9	150	250	350	450	1.200
Client10	2.500	0	0	0	2.500
Client11	0	3.500	0	0	3.500
	4.520	4.180	540	590	9.830

and here you can see, how I would like to show the data

	Country
Customer	Belgium	UK	Netherlands	Spain	Total	Cnt
Client9	150	250	350	450	1.200	4
Client2	500	250	130	50	930	4
Client8	0	20	30	40	90	3
Client6	250	100	0	0	350	2
Client1	100	0	0	50	150	2
Client4	0	10	30	0	40	2
Client11	0	3.500	0	0	3.500	1
Client10	2.500	0	0	0	2.500	1
Client7	1.000	0	0	0	1.000	1
Client3	0	50	0	0	50	1
Client5	20	0	0	0	20	1
	4.640	4.260	600	680	10.180

I was also playing, creating a measure, which gives me by customer the count, in how many countries it had sales. But did not been able to create these,

Any help you might can provide, is greatly appreciated.

Thanks

[Anonymous]

Hi @Manne_DE ,

Please refer the attached .pbix file:

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Manne_DE]

Thank You for quick reply to my problem. I have tried your solution, as I am still on the April 2023 version and cannot upgrade, it caused some errors telling me that you created the solution in a newer version.

However, I still could check out what you did and the Dax you wrote. Currently I am not sure, I can implement your solution, so I am still looking into this.

Thank You so far ! Appreciate it