Forum Discussion
Complex Ranking in a Star Schema
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 - thanks for the offer of help, I can send over a sample dataset, with a few different ways we've tried in folders. Can you suggest a way to share this with you?
A breakdown of what I can send is below:
SimpleRank - is a simplistic view that only ranks on Total qty
RankStg2 - is a 2 stage calculation, that factors in Total value to remove ties.
RankStg3 - is the same calc but split out to 3 measures.
Final Rank Solution is the end game by rolling all calcs into one measure, when testing this has computed much quicker than splitting out.
As you'll see from the table in the report, each rank only works when using the PRODUCT_ATTRIBUTES table. And as mentioned in my last message, we cannot use CROSSJOIN and/ALLEXCEPT due to the size of the data model (currently 13 GB).
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.
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.