The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, how are u? I am new in the community. I was creating a RANKX function i was having trouble wih it.
I have the table below:
Cliente is an unique identifier for a customer and "CuitsConsultadosUnicos" is the number of times that customer enter to a website.
I want to create a rank of the customer that enter to the website. Im expecting the next result
RANK CLIENTE SUM(CuitsConsultadosUnicos)
1 * 44
2 30709584193 2
But instead of that i get
RANK CLIENTE SUM(CuitsConsultadosUnicos)
1 * 44
5 30709584193 2
Here are the measure that ive used to create the rank:
Q_CUITS_CONSULTADOS_U =
SUM(Piloto[CuitsConsultadosUnicos]),
RANKING_CLIENTE =
RANKX(
ALL(Piloto),
[Q_CUITS_CONSULTADOS_U]
)
Thank you so much!
Solved! Go to Solution.
@Anonymous , try like
RANKING_CLIENTE =
RANKX(
ALL(Piloto[CLIENTE]),
[Q_CUITS_CONSULTADOS_U]
)
or
RANKING_CLIENTE =
RANKX(
allselecetd(Piloto[CLIENTE]),
[Q_CUITS_CONSULTADOS_U]
)
@Anonymous , try like
RANKING_CLIENTE =
RANKX(
ALL(Piloto[CLIENTE]),
[Q_CUITS_CONSULTADOS_U]
)
or
RANKING_CLIENTE =
RANKX(
allselecetd(Piloto[CLIENTE]),
[Q_CUITS_CONSULTADOS_U]
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
100 | |
76 |