Forum Discussion
Visual Exceeded Available Resources
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 !!
1 Reply
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.
