Rank by Grouping of multiple columns

[amishra01]

Hi All,

I have a scenario where I have3 years of Data and on that i need to Calculate Rank the prices by Date and Location column.

The Granularity of data is hourly , so per day for each location I have prices for 24 hours.

My requirement is rank the prices for each day by mktlocation . I tried  using

top4 =
VAR RANK_ = RANKX(ALL(Table[Date],table[Location]),CALCULATE(SUM(table[TotalPrice])),,DESC)
//returns top 4 months only
RETURN
CALCULATE ( MAX ( 'Table'[TotalPrice]), FILTER ( 'Table', RANK_ <= 4 ) )

This code gives me error -This visual has exceeded the available resources". 

I also tried grouping on model level but the result never showed up for me.

Any help would be really appreciated.

[olgad · Accepted solution]

Hi, 

RANKX(

      CROSSJOIN(

        ALL('Table'[Location]),

        ALL('Table'[Date])),

      [Total Price]

)

Please calculate total price as a separate measure
Total Price= SUM(Total Price)