Forum Discussion
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(),
isb...
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