topic USERELATIONSHIP visual has exceeded available resources in DAX Commands and Tips

USERELATIONSHIP visual has exceeded available resources

Anonymous — Thu, 12 Aug 2021 14:44:43 GMT

Hi all,

I´m curently using Azure analysis services and I´m having issues with USERELATIONSHIP, the original measure( Mesaure1) works just fine but when I evaluate it within the function ( Measure2) , I get the error: visual has exceeded available resources.

in the second one I have it taking into acocunt a different date table because it is meant to be like this while Im filtering.

( having two date filters)

Measure1 :=

CALCULATE (
DISTINCTCOUNT ( FACT_1[ID] ),
FILTER (
SUMMARIZE (
FACT_1,
FACT_1[ID],
"test", CALCULATE ( AVERAGE( ( FACT_1[CANAL] ) )
)),[test]=10
))

Maeasure 2:=
CALCULATE (
[Measure1],
ALL ( DIM_DATE),
USERELATIONSHIP( DIM_DATE[ID_fecha], DIM_DATE_2[ID_fecha] )
)

Thanks in advance.

Re: USERELATIONSHIP visual has exceeded available resources

amitchandak — Wed, 11 Aug 2021 05:01:39 GMT

Anonymous , Is this not supposed to be between the Date table and Fact?

Maeasure 2:=
CALCULATE (
[test],
ALL ( DIM_DATE),
USERELATIONSHIP( DIM_DATE[ID_fecha], FACT_1[ID_fecha] )
)

Else share data model .

You can increase data management cache in file-> Option and settings -> option -> Data Load and check too

Re: USERELATIONSHIP visual has exceeded available resources

Kucrapok — Thu, 12 Aug 2021 13:20:07 GMT

1) what happen if you only use measure 2 on your report? Do you have the issue?

2) In measure 2, what is the Dax behind the test measure?

Re: USERELATIONSHIP visual has exceeded available resources

Anonymous — Thu, 12 Aug 2021 14:49:27 GMT

I did solved my issue by changing the main measure ( Measure1) for this one:

MeasureNew:=

VAR C10= CALCULATETABLE(VALUES(FACT_1[ID]),FACT_1[CANAL]=10) // IDs within canal 10

VAR C14= CALCULATETABLE(VALUES(FACT_1[ID]),FACT_1[CANAL]=14) IDs within canal 14

VAR EX10= EXCEPT(C10,C14) unique IDS in canal 10 but non in canal 14

RETURN

COUNTROWS(EX10) count of ids just within canal 10