topic Re: Dax Maxx function, but ignoring the Filter, and Slicers in DAX Commands and Tips

Dax Maxx function, but ignoring the Filter, and Slicers

Anonymous — Thu, 24 Oct 2024 12:21:19 GMT

I have a calculation that calculates the MAX value of a Measure:
I used the Removefiltes it works but if you filter the actual visual the dax does not work anymore, kind of like a double negative:

My visual is a gauge, that is filter on the side panel on a specific Vertical.
This is my code:

Max Outsourced Market Size = CALCULATE( MAXX( VALUES( Verticals[V1] ), CALCULATE( [Market Size Supply Chain] - [Market Size Outsourced], ALLEXCEPT(Verticals, Verticals[V1]) ) ), ALLEXCEPT(Verticals, Verticals[V1]) )

I think it should also ignore the SELECTEDVALUE. Please help anyone.

Re: Dax Maxx function, but ignoring the Filter, and Slicers

bhanu_gautam — Thu, 24 Oct 2024 12:43:38 GMT

Anonymous ,Try using

Max Outsourced Market Size =
CALCULATE(
MAXX(
VALUES(Verticals[V1]),
CALCULATE(
[Market Size Supply Chain] - [Market Size Outsourced],
REMOVEFILTERS(Verticals)
)
),
REMOVEFILTERS(Verticals)
)

Re: Dax Maxx function, but ignoring the Filter, and Slicers

Anonymous — Thu, 24 Oct 2024 14:22:58 GMT

Hi bhanu thank you for your response, your dax does the same as mine, it only ignores the first filter not that second one.

Re: Dax Maxx function, but ignoring the Filter, and Slicers

FreemanZ — Thu, 24 Oct 2024 14:31:54 GMT

hi Anonymous ,

try like:

Max Outsourced Market Size =
CALCULATE(
MAXX(
VALUES( Verticals[V1] ),
CALCULATE(
[Market Size Supply Chain] - [Market Size Outsourced],
ALL(Verticals),
VALUES(Verticals[V1])
)
),
ALL(Verticals),
VALUES(Verticals[V1])
)

Re: Dax Maxx function, but ignoring the Filter, and Slicers

divyed — Thu, 24 Oct 2024 14:33:29 GMT

Hello Anonymous ,

To ignore selectedvalues, have you tried using all ?

Max Outsourced Market Size =
CALCULATE(
MAXX(
VALUES( Verticals[V1] ),
CALCULATE(
[Market Size Supply Chain] - [Market Size Outsourced],
ALL(Verticals[V1]) -- This removes any filters on Verticals[V1]
)
),
ALL(Verticals[V1]) -- Ignores the filter on Verticals[V1] for the outer CALCULATE as well
)

I hope this helps .

Cheers

Re: Dax Maxx function, but ignoring the Filter, and Slicers

Anonymous — Thu, 24 Oct 2024 15:20:15 GMT

HI FreemanZ thank you for your response, this gives the similar output, without ignoring the second filter.

Re: Dax Maxx function, but ignoring the Filter, and Slicers

Anonymous — Thu, 24 Oct 2024 15:22:13 GMT

Hi divyed thank you for your response, your dax does the same as mine, it only ignores the first filter not that second one.

Re: Dax Maxx function, but ignoring the Filter, and Slicers

Anonymous — Mon, 28 Oct 2024 02:55:58 GMT

Hi Anonymous ,

Can you provide the .pbix file without sensitive data? And show the expected results as a picture?

If you are unsure how to upload data please refer to

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Wenbin Zhou

Re: Dax Maxx function, but ignoring the Filter, and Slicers

Anonymous — Thu, 31 Oct 2024 08:43:40 GMT

The solution was to create individual measures for each of the v1's then use the original script, then create the visuals using those individual scripts, then use the maxx function below on the max value of the gauge. Seems the problem is that you cannot ignore two filters in one formula.