Forum Discussion

saud968's avatar
saud968
Icon for Memorable Member rankMemorable Member
3 years ago

Top 10 with Multiple Columns

I have multiple columns and I am trying to get the dynamic top 10 with NOC Completed Rate and FTR Percentage, however, while creating RANKX Dax is getting an error "special flag is not allowed as an ...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Try this measure

Measure = calculate([FTR percentage],TOPN(5,all(TICKET_LIFECYCLE_FACT[FCD_FAMILYNAME]),[FTR percentage]),values(TICKET_LIFECYCLE_FACT[FCD_FAMILYNAME]))

To the visual, drag FCD Family name and this meausre.

  • saud968's avatar
    saud968
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Below is the table looking after using your DAX also, I tried to combine the RANK for two columns RANK FTR and Rank NOC Completed with DAX - 

    Combined Rank = (TICKET_LIFECYCLE_FACT[Rank FTR] + TICKET_LIFECYCLE_FACT[Rank NOC Completed]) / 2



     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      How do you expect me to help you without having access to the PBI file?  Show the expected result there very clearly.

      • saud968's avatar
        saud968
        Icon for Memorable Member rankMemorable Member
        3 years ago

        Hi Ashish_Mathur , 

         

        I appreciate your help I am not sure if I can share the PBX file, however, I will try to see if I can get a sample data and submit the same in PBX file