Forum Discussion
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
- amitchandak
Super User
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")