Forum Discussion

jlinhenley's avatar
jlinhenley
Frequent Visitor
7 years ago
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...
Need Help
  • jlinhenley's avatar
    jlinhenley
    7 years ago

    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()))

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Upload to Google Drive and share the download link here.

jlinhenley's avatar
jlinhenley
Frequent Visitor
7 years ago

Hi, can you download this link

 

pbix

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    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])

    • jlinhenley's avatar
      jlinhenley
      Frequent Visitor
      7 years ago

       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..

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        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.