Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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êsCheck out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
107 | |
101 | |
92 | |
69 |
User | Count |
---|---|
172 | |
135 | |
132 | |
101 | |
95 |