TOP 5 Categories with top 3 Subcategories

[Harpreet_14]

Hi,

I have created a measure for TOP 5 Categories with top 3 Subcategories  which is giving me correct count and Rank.

But problem is when I add a slicer of confidence score on the page. It gives me incorrect results. Rank is also incorrect after adding slicer. 
Without Slicer:

With Slicer:

Formula:

Rank Based on ticket count =

if(

    ISINSCOPE('Automation_Live'[Application_Name])&&HASONEVALUE('Automation_Live'[Application_Name]),

    RANKX(

        CALCULATETABLE(

            VALUES('Automation_Live'[Application_Name]),

            ALLSELECTED('Automation_Live'[Application_Name]),

            ALLEXCEPT('Automation_Live','Automation_Live'[Client_ID])

        ),

        [ML Automation ticket count]

    )

)

Need the solution where i can get the desired result without ties.

Thanks

[Anonymous]

Hi @Harpreet_14 

It still seems to be sorted as it was before the subclass was selected. The result is the order of the original parent class. And with duplicate values, it's hard not to use ties to accomplish your purpose.

Best regards,
Community Support Team_ Scott Chang