Forum Discussion

cuongle's avatar
cuongle
Icon for Advocate II rankAdvocate II
9 years ago
Solved

TOP N Filter cannot be used twice

TOP N Filter cannot be used twice in Power BI:     Is there any workaround that we can do in this case?
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Perhaps using RANKX to rank either suppliers or months and then just using a < filter?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Can you explain the use case for having two TOP N filters?

  • cuongle's avatar
    cuongle
    Icon for Advocate II rankAdvocate II
    9 years ago

    I would like show top 10 suppliers based on spend on 6 latest months. So, in that case I want to have TOP 10 Suppliers and TOP 6 months

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Perhaps using RANKX to rank either suppliers or months and then just using a < filter?