Forum Discussion
DAX Rank with Grouping
I used the following measure to Rank items within their respective Product Families: Product Family Rank - POS Sales = RANKX(ALLEXCEPT(Material,Material[Prod Hier: Product Family]),'POS Sales'[P...
Anonymous , Try measures like
Create a measure assuming [POS Sales] is a measure
M1= calculate([POS Sales], filter(allselected(Material), Material[Prod Hier: Product Family] = max(Material[Prod Hier: Product Family])))
Product Family Rank - POS Sales = RANKX(allselected(Material[Prod Hier: Product Family]),[M1])
No matter how much I filter down, I am still seeing "this visual has exceeded the available resources" when I input this formula in. Do you have an alternative?