1 of 1 people found this helpful
I would use and lod that included all the dimensions that you plan to filter on and aggregate it on the measure you intend to use for a rank
then do a rank_unique(sum(lod),'asc') --- then use the rank in a filter <= 7
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.