Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am using tie breaker for the first time but can't get it working.
Maybe someone can help.
https://www.dropbox.com/scl/fi/rtv3ghfv12g1vg7fp0vmt/test.pbix?rlkey=pipd1q7kysjmok758og3bmlsg&dl=0
If you look at the table in the attached pbix you see 4 measures:
In measure 4 I use measure 3. I thought by using this the Rank of Fatz Group would become 173 (instead of 172) and that of SHISEIDO Ltd would become 164 instead of 163.
But that's not happening.
I also don;t know why the Rand of Fatz Group and Voonyx Group is still the same.
Can someone help me?
Regards
Ron
Solved! Go to Solution.
Hi @PowerRon ,
Try the following code:
RankSum =
RANKX(ALLSELECTED('Customers'[Customer Names]),
[Sum Quantity]+CALCULATE( SUM(Customers[Customer Index])/100)
,,DESC)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
I'd solve it with the RANK function
Measure = RANK(DENSE,SUMMARIZE(ALLSELECTED(Sales),Customers[Customer Names],"A",[Sum Quantity]),ORDERBY([A],desc,Customers[Customer Names],desc))
Hope this helps.
Hi @PowerRon ,
Try the following code:
RankSum =
RANKX(ALLSELECTED('Customers'[Customer Names]),
[Sum Quantity]+CALCULATE( SUM(Customers[Customer Index])/100)
,,DESC)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Miguel, thnx. It works. Why doesn't it work with RAND()? Any idea?
Regards
Ron
Because when you use the rand has a measure the value gets recalculate and usually for the metric where you reusing the value its always the same so no difference.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |