Forum Discussion
curtismob
3 years agoHelper IV
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
3 years agoSuper User
curtismob given the example of your data what do you expect the minimum to be?
- curtismob3 years agoHelper IV
I apologize, I just re-read my earlier post and it was not clear. I re-worded it below.
With Community4 deselected in the Comminty slicer, The desired minimum cost would be 1007, but it remains 0.
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%