Forum Discussion
custom sorting in a matrix table
Hi bantoszewski
You can use calculate on your measure to remove the Month filter to rank the productsRank measure =RANKX(ALLSELECTED('Test Table'[Product]),CALCULATE([SalesAm],ALLSELECTED('Test Table'[Month])),,DESC,Skip)If the year/month are from a seperate calendar table you could do AllSelected(CalendarTable) or if they are from the sale Date column use AllSelected(table[date]). If the same table different columns AllSelected(table[month],table[year]).
It looks like the bookmarks are gonna work fine.
However I see my ranking function needs some modification.
In the first example it worked fine because the sales values were what they were. If I modify them (look below) the sorting is not good.
I need to rank Sales taking into account just total sales of Products, and the rest (mon
I want to add Year as well
Of course it is just a sample. The real table has thousand of rows, tens of measures, etc.
I suppose something should be done to RANKX function, for example not ALLSELECT but maybe ALLEXCEPT or mabe some FILTER inside. I tried to google it but without success yet. I am a beginner.
Super UserHi bantoszewski
You can use calculate on your measure to remove the Month filter to rank the products