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...
Thank you for the suggestion, but unfortunately, this does not take into account the grouping requirement. The suggested measure calculates the minimum cost for all selected options, as opposed to the minimun cost within the group. The measure below works correctly, until a community is deselected in the community slicer.
Cost MIN =
CALCULATE(
MINX (
SUMMARIZE(
Options,
Options[Option],
Community[_cCommunity with Number],
Options[_cOption Plan/Elev]),
'Option Cost'[Cost Current] ),
ALLEXCEPT ( Options, Options[Option], Community[Division]))