Forum Discussion
cuongle
9 years agoAdvocate II
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?
- 9 years ago
Perhaps using RANKX to rank either suppliers or months and then just using a < filter?
Greg_Deckler
9 years agoCommunity Champion
Can you explain the use case for having two TOP N filters?
cuongle
9 years agoAdvocate II
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_Deckler9 years agoCommunity Champion
Perhaps using RANKX to rank either suppliers or months and then just using a < filter?