Forum Discussion

msa_007's avatar
msa_007
Frequent Visitor
2 years ago

Measure Possible Context Issue

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.

 

2 Replies

  • 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

  • msa_007's avatar
    msa_007
    Frequent Visitor

    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.