Hello,
I created a measure that gets the TopN categories per item of interest and put the rest on an Others category. I implemented something similar to this except the user no longer has the option to change N in TopN. It works well, up until I add a date variable to the matrix visual I want to display. What happens is the generated Row Total only shows the top N counts, but for each month it also gets the categories that are the part of the top N for that month. What I want is to just include the categories that have the highest count across the specified period.
After searching the forums, I came across a topic that seemed to be related to my problem; however, it only focuses on the top N for the last month. I cannot seem to make it work for the top 5 across all the months. I would appreciate some help.
