Forum Discussion
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...
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.
Option Community Plan/Elev Current Cost Min Cost Variance $ Variance % OPTION1 Community1 +/+ 1499 0 1499 100% OPTION1 Community2 +/+ 2173 0 2173 100% OPTION1 Community3 +/+ 1050 0 1050 100% OPTION1 Community4 +/+ 0 0 0 0% OPTION1 Community5 +/+ 1007 0 1007 100% OPTION1 Community6 +/+ 1007 0 1007 100% Community4 deselected in the Comminty slicer, but the minimum of current cost is still 0, instead of 1007
Option Community Plan/Elev Current Cost Min Cost Variance $ Variance % OPTION1 Community1 +/+ 1499 0 1499 100% OPTION1 Community2 +/+ 2173 0 2173 100% OPTION1 Community3 +/+ 1050 0 1050 100% OPTION1 Community5 +/+ 1007 0 1007 100% OPTION1 Community6 +/+ 1007 0 1007 100% Thank you again,
