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,

Could you share a dataset and show the expected result.

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