cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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. 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Helper I
Helper I

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
Super User
Super User

@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

 



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors