Forum Discussion
How can I remove filters from a RANKX function in powerbi?
I've been struggling with removing filters from the rank calculation in dax. I have a sample table with units per store for individual items broken out by their respective Department, Category, Sub-...
I have a suspicion that you won't be able to get this to work without having department and category columns in a separate dimension table due to auto-exists eliminating rows that you want to keep.
Try creating a dimension table for those columns.
I will try that out! As far as the dimension table goes, would it just be a 3 column table of all the possible combinations of Department, Category, and Subcategory? Or would it be a dimension table with all the item info available (UPC, Department, Category, SubCategory, ParentBrand, and Parent Comapny)?
I was wondering if you found a solution to this issue. I am having the exact same problem.