MINX Measure Ignoring Slicer Filtering

Helper IV

3 years ago

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,

curtismob

Forum Discussion

Related content

Make measure ignore specific filter

Ignore filter for a measure

Power BI – YoY Measure Ignoring Product Filter but Respecting Slicers

DAX Measure ignore filter/slicer selection

Creating a measure that is the value of another measure but ignores a filter