how to resolve data exceed error in service

[Anonymous]

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.

[lbendlin]

Please note that 

VALUES(Sales[PARTNERCODE])

and

ALL(Sales[PARTNERCODE])

are most likely the same thing in your scenario.  What's the cardinality of that column?