Power BI (DAX) How to Ranking by percentage

[huafuuw_cho]

I  have a data set "Test1" with repeat customer with all customer by month. then I count and calculate to percentage

CustomerID	AREA	Repeat
001	A
001	A	RR
002	A
003	A
004	B
005	C
001	A	RR
006	B
005	C	RR
007	A
008	B
009	C
010	C

Count_all_customer = COUNTROWS(Test1)

Count_Repeat_customer = COUNTROWS(FILTER(RELATEDTABLE(Test1),Test1[Repeat]="RR"))

%repeat_customer = ([Count_Repeat_customer]/[Count_all_customer])

Now, I want to Ranking Percent Repeat Customer by Area like this

AREA	all Customer	repeat Customer	%RR	Ranking
A	6	2	33%	3
B	3	0	0%	1
C	4	1	25%	2

when I used RANKX --> Result all ranking is "1"

Please advise how to correct this formula to achieve the desired result

[ValtteriN · Accepted solution]

Hi, 

I am not sure I follow but as I understood you want to RANK your values based on %repeat_customer

Here is how to do this:

Ranking M = RANKX(ALL('Table (2)'),[%repeat_customer],,ASC)

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[huafuuw_cho]

thanks you , that's work   😃