Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ( Measu...
  • Anonymous's avatar
    Anonymous
    5 years ago

    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 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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