Getting same rank for different amount

[Anonymous]

Hi - I am trying to rank the products based on gross profit measure. I am getting same rank sometimes even though amount is different. Below is the screenshot of the issue and the measure I am using -

Can someone suggest what is going wrong with my measure.

Measure - 

Rank_brandMTD = RANKX (

CROSSJOIN (

ALLSELECTED ( 'DimBrand'[Brand Key] ),

ALLSELECTED ( 'DimBrand'[Brand Parent Name] )

),

[Actual.GrossProfit],

,

DESC,

Dense

)

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

HI  @Anonymous ,

In my tests this is no problem, you can check my pbix file (my file is created based on the information you have provided so far) and you can reproduce your problem in my pbix and I will adjust it to the specific problem.

Best Regards

Lucien

[Fowmy]

@Anonymous 

Please the following measure to rank by two columns

Rank_brandMTD =
RANKX (
    SUMMARIZE (
        ALLSELECTED ( 'DimBrand' ),
        'DimBrand'[Brand Key],
        'DimBrand'[Brand Parent Name]
    ),
    [Actual.GrossProfit],
    ,
    DESC,
    DENSE
)

[Anonymous]

@Fowmy  - It seem working, but confusing when I put filter on rank_brandMTD. I need to  select brands with ranks 6 to 10. When I do that, I see rank starting 1 to 5. If I use filter to choose rank 1 to 10, then I see same ranks as below - 

The filter I tried in this case