Measure Possible Context Issue

[msa_007]

Hi there,

The following measure is causing my visual to "...exceed the available resources"

CF_ReviewStatusDays = 
var v_formatting =
    SWITCH(
        TRUE(),              
        isblank(max('Document Review (Workflow)'[Actual Completion Date])),0,
        max('Document Review (Workflow)'[Days (before/after) Scheduled Completion])>=1                      //1-4 days before scheduled completion date
            && max('Document Review (Workflow)'[Days (before/after) Scheduled Completion])<5, 1,
        max('Document Review (Workflow)'[Days (before/after) Scheduled Completion])>=5, 2,                  //5+ days before scheduled completion date
        max('Document Review (Workflow)'[Days (before/after) Scheduled Completion])<0, -1                   //Overdue
    )
    RETURN
    v_formatting

The measure is trying to provide some coding to support conditional formatting on my table.

If the completion date is blank then return 0

If the number of days until scheduled completion is between 1-4 then return 1

If the number of days until scheduled completion is greater than 5 then return 2

and if the number of days until scheduled completion is negative return -1

Is the problem associated with mixing my date table with numbers or a context problem?  Please help.

The model is as follow:

Any help appreciated.  thanks.

[msa_007]

Hi @amitchandak,

Thanks for your reply.

I think you didn't see the date component of the dax, and I think that was the main issue I was having.  Any ideas on that?  Many thanks for your help.

[amitchandak]

@msa_007 ,Try

CF_ReviewStatusDays =
var _max = max('Document Review (Workflow)'[Days (before/after) Scheduled Completion])
var v_formatting =
SWITCH(
TRUE(),
isblank(_max),0,
_max <0, -1 , //Overdue
_max <5, 1,
_max>=5, 2 //5+ days before scheduled completion date

)
RETURN
v_formatting