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...
curtismob not sure what that means. What do you mean by grouping? if you clarify everything in one go, it will help.
Hopefully this will help to clarify the requirement to find the minimum cost within a group, where the group in this case is Option. I have added data examples for 2 options, as opposed to only 1.
Data prior to any slicer filtering. This data is correct, before removing COMMUNITY4.
Option Community Plan/Elev Current Cost Min Option Cost OPTION1 COMMUNITY1 1/A 1007 0 OPTION1 COMMUNITY2 1/A 2173 0 OPTION1 COMMUNITY3 1/A 1007 0 OPTION1 COMMUNITY4 1/A 0 0 OPTION1 COMMUNITY5 1/A 1499 0 OPTION1 COMMUNITY6 1/A 1050 0 OPTION2 COMMUNITY1 1/A 1571 0 OPTION2 COMMUNITY3 1/A 1571 0 OPTION2 COMMUNITY4 1/A 0 0 OPTION2 COMMUNITY6 1/A 1627 0 Data after slicer filtering removing COMMUNITY4, 0 remains the minimum, even though COMMUNITY4 with the minimum of 0 for both OPTION1 and OPTION2, have been removed using slicer selections. There is no longer a Current Cost of 0.
Option Community Number Plan/Elev Current Cost Min Option Cost OPTION1 COMMUNITY1 1/A 1007 0 OPTION1 COMMUNITY2 1/A 2173 0 OPTION1 COMMUNITY3 1/A 1007 0 OPTION1 COMMUNITY5 1/A 1499 0 OPTION1 COMMUNITY6 1/A 1050 0 OPTION2 COMMUNITY1 1/A 1571 0 OPTION2 COMMUNITY3 1/A 1571 0 OPTION2 COMMUNITY6 1/A 1627 0 These are the desired results, after the slicer filtering removing COMMUNITY4.
Option Community Number Plan/Elev Current Cost Min Option Cost OPTION1 COMMUNITY1 1/A 1007 1007 OPTION1 COMMUNITY2 1/A 2173 1007 OPTION1 COMMUNITY3 1/A 1007 1007 OPTION1 COMMUNITY5 1/A 1499 1007 OPTION1 COMMUNITY6 1/A 1050 1007 OPTION2 COMMUNITY1 1/A 1571 1571 OPTION2 COMMUNITY3 1/A 1571 1571 OPTION2 COMMUNITY6 1/A 1627 1571 Thanks again,
