Dynamic Table Rank - how to get this to work?

Hi Anonymous 

Try the below

Rank = 
VAR tbl = CALCULATETABLE(
    VALUES(FactSales[Aging]),
    ALLSELECTED()
)
RETURN 
RANKX(
    tbl, 
    ROUND(
        CALCULATE(
            AVERAGE(FactSales[Aging]),
	        DATESYTD(FactSales[ClosedDate]),
	        FILTER ( 
                FactSales, 
                AND ( 
                    FactSales[Scorecard Bucket] IN { "FILTERS"},  
                    FactSales[OpenClosed] IN {"Closed" } 
                )
            )
        ),
        1
    ),,,
    Dense
)

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.