Forum Discussion
WhatIf dimension issue with slicer
I am using a WhatIf to determine if a response time has "met" target, the target being the what-if. We want to see if we change the target, how many will meet the target. This works perfectly if al...
Hi Anonymous
The reason for the behaviour you're experiencing is that the measure ([MeetsTarget]) that you defined is being calculated for all members, regardless of whether there is a value for [ResponseTime] or not.
MeetsTarget = if(Parameter[Parameter Value]>[ResponseTime];"Yes";"No")This behaviour is because the Parameter[Parameter Value] measure always has a value.To fix the measure to exhibit the behaviour you want, all that is needed is to check whether [ResponseTime] is BLANK(), and handle that differently.MeetsTargetFixed = if(ISBLANK([ResponseTime]);BLANK();if(Parameter[Parameter Value]>[ResponseTime];"Yes";"No"))Hope this helps**** PLEASE NOTE, MY LOCALE SETTINGS USE ";" AS DELIMETERS, YOURS MAY USE ","
Hi Anonymous
The reason for the behaviour you're experiencing is that the measure ([MeetsTarget]) that you defined is being calculated for all members, regardless of whether there is a value for [ResponseTime] or not.
MeetsTarget = if(Parameter[Parameter Value]>[ResponseTime];"Yes";"No")
This behaviour is because the Parameter[Parameter Value] measure always has a value.
To fix the measure to exhibit the behaviour you want, all that is needed is to check whether [ResponseTime] is BLANK(), and handle that differently.
MeetsTargetFixed = if(ISBLANK([ResponseTime]);BLANK();if(Parameter[Parameter Value]>[ResponseTime];"Yes";"No"))
Hope this helps
**** PLEASE NOTE, MY LOCALE SETTINGS USE ";" AS DELIMETERS, YOURS MAY USE ","