Visual has exceeded the available resources

[Mohan_Vemana]

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

[amitchandak]

@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")