USERELATIONSHIP visual has exceeded available resources

[Anonymous]

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. 

[Anonymous · Accepted solution]

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 

[Kucrapok]

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?

[amitchandak]

@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