Forum Discussion

Mohan_Vemana's avatar
Mohan_Vemana
New Member
3 years ago

Visual has exceeded the available resources

Hi All,

I am trying to implement a report in which i'm getting below error.

 

The issue is because of the Measure created in the report. I have created the measure containing 2 tables(contains only 9 records and 3 records respectively). But when bringing the measure into the report it is throwing the error "Visual has exceeded the maximum resources". When I tried to remove the measure, the visual displays data. Can you provide a solution on how I can build the report that includes the measure with no error...

 

The measure used is 
Measure = IF(
(MAX(DIM_SALES[Notification]) = "A" || MAX(DIM_SALES[Notification]) = "B") &&
MAX(DIM_SALES[ANS]) = "Yes" &&
(MAX(DIM_APPL[Type]) = "Phone" || MAX(DIM_APPL[Type]) = "Email"),
MAX(DIM_SALES[Date]), "None")

 

Thanks in advance,

Mohan

1 Reply

  • Mohan_Vemana , Try if this can help

     

    Measure = IF(
    (MAX(DIM_SALES[Notification]) im {"A","B"} ) &&
    MAX(DIM_SALES[ANS]) = "Yes" &&
    (MAX(DIM_APPL[Type]) in{ "Phone" , "Email"} ),
    MAX(DIM_SALES[Date]), "None")