Forum Discussion
Solved
using RANKX and allselected together with visual filters
Hi, I have a problem i cannot figure out. I have a matrix, with two levels of aggregation and also has a RANKX measure RANKX(ALLSELECTED(ETOs[Job Number]), [Total ETOs To Date]) It is using ALL...
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,
Could you share a dataset and show the expected result.
How do I share the pbix? Can i sent it to your email?
Hi,
Upload to Google Drive and share the download link here.