Ranking measure with Table variable

Hi sqlguru448 ,

Be aware that making a summarizaition of a full table will bring for sure performance issues, in your case you are using the FACT table that I assume have a huge number of data so be aware of that.

Try the following code:

Measure = 
var temp_table =
        FILTER (
            SUMMARIZE (
                ALLSELECTED ( Customer[Name] );
                Customer[Name];
                "Total_Sales"; [Sales Amount]
            );
            [Sales Amount] > 0
        )

var Ranking = RANKX(temp_table; [Sales Amount])


RETURN
    Ranking

Then filter out all rankings above 10.