Forum Discussion
rauerfc
5 years agoFrequent Visitor
RANKX returning variable, TOP 1, 2, 3, 4
I have a table that has sales by month, account manager, and MRK. I need that the measure returns the TOP 1 selling MRK and another one for 2, 3, and 4. Output = 130 or 40 or 110 Each measure will...
rauerfc
5 years agoFrequent Visitor
So, each account manager has a different best selling, second best, third best MRK.
My visualization was built to show 4 graphs that will return the same information (Coverage), for the first, second, third, and fourth best-selling MRK.
How can I show only information from the best selling in the first graph, 2, 3 and so?
I'm trying to filter with the rankx selecting 1 and isn't working:
rank_mrk = RANKX(ALLSELECTED(tab_mrk[MRK]),[sum_rank],, DESC, Dense)
Ashish_Mathur
Super User
5 years agoHi,
Share the link from where i can download your PBI file.