Forum Discussion
MINX Measure Ignoring Slicer Filtering
Hello, I am still trying to resolve this issue. I have used previous suggestions in the post, which have gotten me closer, but I still need help getting the MINX to work with slicer selections. Below is the link to the desktop file for the data and report examples below.
https://drive.google.com/file/d/10PEccWeAmykc42N9yB5o_OL30ZvkmL4q/view?usp=drive_link
Here are the Curr Cost and Min Curr Cost measures:
_mOption Cost Current Date =
VAR
ActiveCost =
CALCULATE(SUM(OptionCost[Cost]),
FILTER('OptionCost',
('OptionCost'[Cost Type] = "B" &&
'OptionCost'[Effective] <= 'OptionCost'[_cCurrent Date] &&
'OptionCost'[Expiration] > 'OptionCost'[_cCurrent Date])
||
('OptionCost'[Cost Type] = "T" &&
'OptionCost'[Effective] <= 'OptionCost'[_cCurrent Date] &&
'OptionCost'[Expiration] > 'OptionCost'[_cCurrent Date] &&
'OptionCost'[Vendor Assignment Effective] <= 'OptionCost'[_cCurrent Date] &&
'OptionCost'[Vendor Assignment Expiration] > 'OptionCost'[_cCurrent Date])
))
VAR
InactiveCostNoVendAssn =
CALCULATE(SUM('OptionCost'[Cost]),
FILTER('OptionCost',
'OptionCost'[Cost Type] = "T" &&
'OptionCost'[Effective] <= 'OptionCost'[_cCurrent Date] &&
'OptionCost'[Expiration] > 'OptionCost'[_cCurrent Date] &&
'OptionCost'[Vendor Assignment Expiration] < 'OptionCost'[_cCurrent Date]
))
VAR
Cost =
IF(ActiveCost <> BLANK(), ActiveCost, InactiveCostNoVendAssn)
RETURN
Cost
_mOption Cost Current Date MIN =
CALCULATE(
MINX (
SUMMARIZE(
Option,
Option[Option],
Community[Community],
Option[Plan/Elev]),
OptionCost[_mOption Cost Current Date] ),
ALLEXCEPT ( Option, Option[Option], Community[Division]))
On this screen shot, the data is correct.
On the following screenshot, the Min Curr Cost for the Option is not recalculated after deselecting certain communities.
Thank you in advance,
Updated Google Drive link:
https://drive.google.com/file/d/10PEccWeAmykc42N9yB5o_OL30ZvkmL4q/view?usp=sharing