Okay, I figured out what was going wrong with your ALLSELECTED construct in Q2. It has to do with how ALLSELECTED behaves when there is no explicit filter context. If instead of using ALLSELECTED as the table modifier in your CROSSJOIN statements when creating your virtual table, use VALUES instead and ALLSELECTED as your CALCULATE/CALCULATETABLE modifier and it all works fine.
Here’s an example of one of the modified measures:
I hope this is helpful. Full solution file attached below.
- Brian
eDNA Forum - Combing Ranks to give FINAL RANK 2 Solution v3.pbix (441.7 KB)