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,
- curtismob2 years agoHelper IV
Updated Google Drive link:
https://drive.google.com/file/d/10PEccWeAmykc42N9yB5o_OL30ZvkmL4q/view?usp=sharing