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?
curtismob
3 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% |