Forum Discussion

mark_endicott's avatar
mark_endicott
Super User
4 years ago
Solved

Complex Ranking in a Star Schema

Hello,  We have been struggling with getting Rankx to work, when theoretically a user could want to include a column from any of the tables in our star schema model in a table, and it not affect the...
RANKX
  • mark_endicott's avatar
    mark_endicott
    4 years ago

    Thanks for the offer of help, but we got this one sorted, the DAX we were using was pretty much correct, just swapped out the dims for the fact inside the ALLSELECT (that was more for future proofing) and took a filter off the table, which was masking that the DAX was actually working. 

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Hi mark_endicott sorry for the delay in replying.  Long day yesterday.

 

Best way to share would be to drop your pbix into OneDrive, Google Drive, etc. and share a link so I can download.

mark_endicott's avatar
mark_endicott
Super User
4 years ago

Thanks for the offer of help, but we got this one sorted, the DAX we were using was pretty much correct, just swapped out the dims for the fact inside the ALLSELECT (that was more for future proofing) and took a filter off the table, which was masking that the DAX was actually working.