Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello , i am new to the community and kinda new to power bi .
I am trying to rank a column(client) based on a measure that i created ( hc fac value) , and to that measure i added rand(hc fac value rand) , to not have any equal values, but the rank is showing as if it exists equal values , i am really struggling..
Can someone help me out please?
Solved! Go to Solution.
Hi @devesqdeves ,
I assume that you have an ID for each of your client if not please create one with the client number (must be unique values) then add the following measure:
Rank_Without_Duplicates =
IF (
HASONEVALUE ( Client[Cliente] )
&& [HC FAC Value] > 0;
RANKX (
ALL ( Client[Cliente] );
(
CALCULATE ( [HC FAC Value] )
+ INT ( CALCULATE ( MIN ( Client[Client ID] ) ) ) / 100000
)
)
)
Check result attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@devesqdeves , You have to add Rand() in Rank (Measure Rank)
Rank(Table,formula) +rank()/1000
Thanks for the input ! But it is not working yet :c
it shows like this
my rank measure =
Hi @devesqdeves ,
I assume that you have an ID for each of your client if not please create one with the client number (must be unique values) then add the following measure:
Rank_Without_Duplicates =
IF (
HASONEVALUE ( Client[Cliente] )
&& [HC FAC Value] > 0;
RANKX (
ALL ( Client[Cliente] );
(
CALCULATE ( [HC FAC Value] )
+ INT ( CALCULATE ( MIN ( Client[Client ID] ) ) ) / 100000
)
)
)
Check result attach.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsIt worked !! Thanks !!
Hi @devesqdeves ,
Don't forget to mark the correct answer to help others.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |