Forum Discussion
Combining Top N filters
Nevermind, I have found the way to solve the problem myself, still thanks v-yuta-msft for attempting to solve my problem.
Community SupportHi JosephL,
Your requirement seems like to rank profits of company by period and achieve top N profits, right? If my understanding is right, you can create a calculate column using DAX formula like pattern below and check if it works well in your senario:
Rank by Period =
RANKX (
FILTER ( Table, Table[Period] = EARLIER ( Table[Period] ) ),
RANKX ( ALL ( Table ), Table[Profit] ),
,
ASC,
DENSE
)
Then you can use visual level filter to achieve the top N profit based on the rank column in each period.
If my understanding is not so correct, could you please show some tables or DAX formula for further research?
Regards,
Jimmy Tao
I am trying to do a comparison between this years profit and previous years profit through the slicers i added above, with year showing the current year and the previous year gp is calculated. The month slicer and week number slicer are further used to select a period of the years.
What I am trying to do is filter the companies by either being the top n of the current year or being the top n in the previous year.
On the left are the company names.
Hope that my clarification is clear.
Nevermind, I have found the way to solve the problem myself, still thanks v-yuta-msft for attempting to solve my problem.