Forum Discussion
Jeanxyz
Power Participant
Power Participantrankx doesn't work
I have a fact_table called 'opportunity' where score data and close date are stored. The fact table is linked to dim-date table via 'close date' column. I have created a rankx measure to rank sco...
I changed the measure as below, now it works properly
//rank measure = rankx(allselected(opportunity),[sum of score])
Indeed, you should use allselected()/all() instead of allexcept() depends on your filtering needs. Glad you solve it.
Paul Zheng _ Community Support Team