Forum Discussion
USERELATIONSHIP visual has exceeded available resources
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.
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
3 Replies
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
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?
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
