Forum Discussion

jordanwhite16's avatar
jordanwhite16
Regular Visitor
1 year ago
Solved

RANK Dax issues!

Hi all,   I have the following dataset at my disposal and I'm looking at ranking the SumColumns shown in the dataset after a specific date of 2024, 9, 8 but as you can see there are duplicate value...
rank
RANKX
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi jordanwhite16 

     

    Since I don't know what your data looks like, please try creating a measure to calculate the rank using the following DAX to see if that helps.

    RankAfterDate = 
VAR SpecificDate = DATE(2024, 8, 9)
RETURN
RANKX(
    FILTER(
        ALL('YourTable'),
        'YourTable'[DateColumn] > SpecificDate
    ),
    CALCULATE(SUM('YourTable'[SumColumn])),
    ,
    DESC,
    DENSE
)

    If it doesn't work, please provide some sample data, and remember to protect your data privacy in the sample data.

     

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523