how to resolve data exceed error in service

Hi,

I have used table and matrix visuals but im getting below visual error when im using below dax measure;

please suggest if need to change the dax measure.

Dax meausre:

Top1 PartnerSales =

var

RankingContext = VALUES(Sales[PARTNERCODE])

Return

CALCULATE([Total Revenue],

TOPN(1,

ALL(Sales[PARTNERCODE]),

[Total Revenue]),

RankingContext)

 

 

 

I hope this gives some idea about the problem. I appreciate any help in solving this problem.

 

@amitchandak @truptis @Samarth_18@mwegener  please help.