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

     

jlinhenley's avatar
jlinhenley
Frequent Visitor
7 years ago

How do I share the pbix? Can i sent it to your email?

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