Visual Exceeded Available Resources

[devesqdeves]

Hi all , hope u are all safe.

When i publish my report , it appears that error in one of my tables , but it only shows that error if i add my Rank column to it.

Without it it works fine.

The measures i am using for Rank and HC FAC are :

Rank =

IF (

HASONEVALUE ( Client[Cliente] )

&& [HC FAC Value] > 0,

RANKX (

ALL ( Client[Cliente] ),

(

CALCULATE ( [HC FAC Value] )

+ INT ( CALCULATE ( MIN ( Client[Id] ) ) ) / 100000

)

)

)

 Measures used to Rank

HC FAC Value = if([HC FAC Indicator Rank]<=[SelectedTopNValueHcFAC], [HC FAC Billing Ano])

SelectedTopNValueHcFAC = if(HASONEVALUE(TopNTable[TopN]), VALUES(TopNTable[TopNValues]),MAXX(VALUES('Client'[Cliente]),[HC FAC Indicator Rank]))

HC FAC Indicator Rank = if(CALCULATE(DISTINCTCOUNT(vw_ConsultantsFinancial[CandidateId]),AllInformationbd[ClientName])>1,RANKX(ALL(Client[Cliente]), [TotalRevenue],,DESC),

RANKX(ALL(Client[Cliente]), [HC FAC Billing Ano],,DESC))

HC FAC Billing Ano = CALCULATE(DISTINCTCOUNT(Bi_Aux_Calc_HC[ConsultantId]),

Filter(Bi_Aux_Calc_HC,

And(Bi_Aux_Calc_HC[ProjectPlayerStartDate]<=LASTDATE(Bi_Aux_Calc_HC[BillingDate]),

OR(Bi_Aux_Calc_HC[ProjectPlayerEndDate]>=FIRSTDATE(Bi_Aux_Calc_HC[BillingDate]),

Bi_Aux_Calc_HC[ProjectPlayerEndDate] = BLANK()))),Bi_Aux_Calc_HC[ProjectPlayerId]

<> BLANK(),USERELATIONSHIP(Bi_Aux_Calc_HC[Date],DimDate[Date]),

USERELATIONSHIP(Bi_Aux_Calc_HC[TeamId],AllInformationBD[TeamId]),

USERELATIONSHIP(Bi_Aux_Calc_HC[ClientId],Client[Id]))

I dont know what to do to otimize that measures , can u please help me ?

Thanks !!

[Anonymous]

Hi @devesqdeves ,

Sorry, not so clear. Can you provide some sample data? Please hide your sensitive information when providing data.

Best Regards,

Stephen Tao

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