RankX

Question

Why am i getting the output like this

bhanu_gautam · Answer

Cyriackpazhe&nbsp;
The issue you're encountering with the RANKX function in Power BI is likely due to the way the function is being used in conjunction with the ALL function. The ALL function removes all filters from the specified columns or tables, which can cause the RANKX function to rank all values as 1 because it is not considering any context for the ranking.
&nbsp;
To fix this, you need to ensure that the RANKX function is applied in a context that allows it to rank the values correctly.&nbsp;
DAXRankX = RANKX(ALL('Calendar'[Date], 'Calendar'[Quarter]),[Total],,DESC,DENSE)

cyriackpazhe · Answer

I'm still getting incorrect result.Also if we do as you mentioned, won't the virtual table contain all possible combinations of year and quarter. The rank would be assigned as per its position in this entire set right

anonymous · Answer

Hi&nbsp;Cyriackpazhe&nbsp;, hello&nbsp;bhanu_gautam, thank you for your prompt reply!
&nbsp;
Please try the following measure:
MeasureTotal = SUM('Table'[Total])RankX = 
IF (
    ISINSCOPE ( 'Table'[Date].[Quarter] ),
    RANKX (
        FILTER (
             ALL('Table') ,
            YEAR ( 'Table'[Date] ) = YEAR ( MAX ( 'Table'[Date] ) )
        ),[MeasureTotal],,DESC
                ,
        DENSE
    ),
    IF (
        ISINSCOPE ( 'Table'[Date].[Year] ),
        RANKX (
            ALL ( 'Table' ),
            CALCULATE (
                SUM ( 'Table'[Total] ),
                ALLEXCEPT ( 'Table', 'Table'[Date].[Year] )
            ),
            [MeasureTotal],
            DESC,
            DENSE
        ),
        BLANK ()
    )
)
Result:

Best regards,
Joyce
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

cyriackpazhe · Answer

but why isn't the meausre i wrote working. It should be correct right&nbsp;

techies · Answer

pls try this -&nbsp;Measure =VAR totalamount = [Enrollment Amount]VAR QuarterRank =&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; ISINSCOPE ( 'DATE'[quarter]),&nbsp; &nbsp; &nbsp; &nbsp;RANKX (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED ( 'DATE'[quarter] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Enrollment Amount],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DESC,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DENSE&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )VAR Result =&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; NOT ISBLANK ( totalamount ),&nbsp; &nbsp; &nbsp; &nbsp; QuarterRank&nbsp; &nbsp; )RETURN&nbsp; &nbsp; Result

Forum Discussion

RankX

6 Replies

Related content

RankX

RANKX

Advanced Ranking (Rankx)

Rank vs Rankx

RankX