Forum Discussion

curtismob's avatar
curtismob
Helper IV
3 years ago

MINX Measure Ignoring Slicer Filtering

The minimum of current cost measure below, works for the most part, but the minimum still pulls values from Community[_cCommunity with Number] and/or Options[_cOption Plan/Elev] combinations, that ha...
Need Help
parry2k's avatar
parry2k
Super User
3 years ago

curtismob it will be easier if you drop some sample data with the expected output. 

curtismob's avatar
curtismob
Helper IV
3 years ago

parry2k , thank you for the quick response.  Unfortunately, my actual dataset it too large to upload, so hopefully the two examples below will help clarify my issue.   

 

OptionCommunityPlan/ElevCurrent CostMin CostVariance $Variance %
OPTION1Community1+/+149901499100%
OPTION1Community2+/+217302173100%
OPTION1Community3+/+105001050100%
OPTION1Community4+/+0000%
OPTION1Community5+/+100701007100%
OPTION1Community6+/+100701007100%

 

Community4 deselected in the Comminty slicer, but the minimum of current cost is still 0, instead of 1007

 

OptionCommunityPlan/ElevCurrent CostMin CostVariance $Variance %
OPTION1Community1+/+149901499100%
OPTION1Community2+/+217302173100%
OPTION1Community3+/+105001050100%
OPTION1Community5+/+100701007100%
OPTION1Community6+/+100701007100%

 

Thank you again,

curtismob