Hi,
When I have these kind of data :
As per picture, I have now some rank which is duplicate (same rank). Altough my rank now "looking" at my column "news count decimal" which is basically have 2 different decimal value if we look at row 1 and 2.
I currently using this DAX :
Before that formula, I also using this :
The result also wrong:
How to get the correct RANK ?
Thanks
@VoltesDev Well, you can always just say To **Bleep** with RANKX: To *Bleep* with RANKX! - Microsoft Fabric Community
PBIX is attached below signature.
Rank Provider 4 =
VAR __Provider = MAX('table1'[Provider])
VAR __Table = SUMMARIZE( ALLSELECTED('table1'), [provider], "__Value", COUNTROWS(DISTINCT('table1'[title])) + RAND() )
VAR __Value = MAXX( FILTER( __Table, [provider] = __Provider), [__Value])
VAR __Result = COUNTROWS( FILTER( __Table, [__Value] >= __Value) )
RETURN
__Result
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@VoltesDev Can't replicate this. See PBIX attached below signature. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@VoltesDev Well, you can always just say To **Bleep** with RANKX: To *Bleep* with RANKX! - Microsoft Fabric Community
PBIX is attached below signature.
Rank Provider 4 =
VAR __Provider = MAX('table1'[Provider])
VAR __Table = SUMMARIZE( ALLSELECTED('table1'), [provider], "__Value", COUNTROWS(DISTINCT('table1'[title])) + RAND() )
VAR __Value = MAXX( FILTER( __Table, [provider] = __Provider), [__Value])
VAR __Result = COUNTROWS( FILTER( __Table, [__Value] >= __Value) )
RETURN
__Result
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
