Forum Discussion
using RANKX and allselected together with visual filters
I ended up solving this issue. What i had to do was create a dimension table on the activities (but dont create a relationship back to the job activities). Then used this as the filter to apply for rank and using the values option in RANKX to actifically blank out the unselected stages. Works well, but computationally quite hard on the cpu.
RANKX( FILTER( ALL(ETOs[Job Number]), [Job Last Stage] IN VALUES('Activities Table'[ActivityDesc])), [Total ETOs To Date], IF([Job Last Stage] IN VALUES('Activities Table'[ActivityDesc]), [Total ETOs To Date], BLANK()))
Hi,
I don't think i have solved it but you may try this. Remove the condition from the Job Last stage filter. Revise your measure to
=RANKX(CALCULATETABLE(ALL(ETOs[JobNo]),FILTER(VALUES(ETOs[JobNo]),[Job Last Stage]<>"Fixing")), [Total ETOs To Date])
Thanks for taking a look. I feel there must be a way to generate the rankings without using ALLSELECTED.
In any case, this seemed like it should be a lot easier..
You are welcome. I have not used ALLSELECTED(). However, even though i have explicitly asked the formula to filter out the Fixing rows, they are appearing in the end result. Sorry but out of ideas now.
I ended up solving this issue. What i had to do was create a dimension table on the activities (but dont create a relationship back to the job activities). Then used this as the filter to apply for rank and using the values option in RANKX to actifically blank out the unselected stages. Works well, but computationally quite hard on the cpu.
RANKX( FILTER( ALL(ETOs[Job Number]), [Job Last Stage] IN VALUES('Activities Table'[ActivityDesc])), [Total ETOs To Date], IF([Job Last Stage] IN VALUES('Activities Table'[ActivityDesc]), [Total ETOs To Date], BLANK()))