Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Okay... have spent a few hours in forumns reviewing a myriad of patterns for RankX. Basic, advanced, using filters, AllSelected, ETC, ETC and still my table shows 1's for every line. I have built similar tables and had zero issues with rankx. The only thing different on this table is instead of fixed date ranges (i.e. last 12, last 6, etc.) these are actual MONTH Date fields for last 12 calendar months. I have to believe this is a major factor in every row showing 1 as rank. There will either be a date slicer or the visual will be "prefiltered" to the last 4 months in the final version.
What am I missing that is preventing this from working???
Any help, as usual, is always appreciated.
SMG
Got a little closer using the following, BUT still not working exactly:
EQ Rank = RANKX(ALLSELECTED('PQ BI Data'),CALCULATE(sum('PQ BI Data'[[EQ]]]),ALLEXCEPT('PQ BI Data','PQ BI Data'[Size Range],'PQ BI Data'[Descript Final])),,DESC,Dense)
EQ Rank = RANKX(ALLSELECTED('PQ BI Data'),CALCULATE(sum('PQ BI Data'[[EQ]]]),ALLEXCEPT('PQ BI Data','PQ BI Data'[Size Range],'PQ BI Data'[Descript Final])),,DESC,Dense)
AND SOLVED... Love it when the answer is finally discovered. Here is the fix///
EQ Vol Rank = If(HASONEVALUE('PQ BI Data'[Descript Final]),Rankx(all('PQ BI Data'[Descript Final]),[Total EQ]) )
Solved! Go to Solution.
Hi @spencer_II,
AND SOLVED... Love it when the answer is finally discovered. Here is the fix///
EQ Vol Rank = If(HASONEVALUE('PQ BI Data'[Descript Final]),Rankx(all('PQ BI Data'[Descript Final]),[Total EQ]) )
Great to hear the problem got resolved!
To close this thread, and help others who may also have this similar issue easily find the answer, I have quoted your solution and marked it as answer.
Regards
Hi @spencer_II,
AND SOLVED... Love it when the answer is finally discovered. Here is the fix///
EQ Vol Rank = If(HASONEVALUE('PQ BI Data'[Descript Final]),Rankx(all('PQ BI Data'[Descript Final]),[Total EQ]) )
Great to hear the problem got resolved!
To close this thread, and help others who may also have this similar issue easily find the answer, I have quoted your solution and marked it as answer.
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |