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 

Anonymous's avatar
Anonymous
Not applicable
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