topic Re: Min & Max Selection from slicer in DAX Commands and Tips

Min & Max Selection from slicer

Chandrashekar — Tue, 18 Jun 2024 10:33:25 GMT

Hello,

How to select minimum and maximum date from the slicer. When I select 13-05-2024 but it is showing 20-May-2024.

am using below formula

Test_min =

VAR min_month_calendar = CALCULATE(minx(ALLSELECTED('Calendar'),'Calendar'[Date])

RETURN format(min_month_calendar,"dd-mmm-yyyy")

Regards,

Chandrashekar B

Re: Min & Max Selection from slicer

Anonymous — Wed, 19 Jun 2024 03:45:44 GMT

Hi,Chandrashekar
I am glad to help you.

According to your description, you want to get the maximum and minimum date of the current selection in the slicer. But the slicer returns the wrong result
here is my test result

I used the dax code you provided and unfortunately got the correct result

This is very strange and I think it has something to do with the computing environment (something is wrong with the computing environment that measure is in)

I noticed that you are using the ALLSELECTED() function

You can see that when I add add a second slicer (both slicers have the same filter fields but different filter ranges)

At this point you can see that there is a problem with the value returned by MEASURE

In fact, when you use the ALLSELECTED function, it takes into account the values of all relevant slicers, and I think this is the reason for your problem (it works fine when there is only one filter, but has problems when there are multiple external filters, which are affected by multiple slicers at the same time, and usually give incorrect composite results).

Your code itself should be fine, but in your calculation environment there may be more than one filter on the date, which will lead to the calculation result is wrong, please check whether there are redundant filters in your settings.

Please check if there are any extra filters in your settings, and make sure that the fields in the measure are consistent with the filtered fields in the slicer.

Calculation environment is very complex but important, please check whether there are any extra filters in your calculation environment, which may affect the result of the measure.
here is my test code:

M_slicer_max = VAR max_ = MAX('Date'[Date_slicer]) RETURN FORMAT(max_,"dd-mmm-yyyy")

Test_max = VAR min_month_calendar = CALCULATE(MAXX(ALLSELECTED('Date'),'Date'[Date_slicer])) RETURN FORMAT(min_month_calendar,"dd-mmm-yyyy")

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Min & Max Selection from slicer

Chandrashekar — Wed, 19 Jun 2024 04:21:52 GMT

Hello,

Thank you for suggestion. I will try and check where is going wrong.

Regards,

Chandrashekar B

Re: Min & Max Selection from slicer

Anonymous — Wed, 26 Jun 2024 06:12:19 GMT

Hi,Chandrashekar
Have you solved your problems?
If you have found suitable solutions, please share them as it will help more users with similar problems. Or you can mark the valid suggestions provided by other users as solutions

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Min & Max Selection from slicer

Chandrashekar — Wed, 26 Jun 2024 06:27:28 GMT

Hello,

As requirement is bit different still working on the solution.

Regards,

Chandrashekar B

Re: Min & Max Selection from slicer

Chandrashekar — Fri, 28 Jun 2024 06:39:12 GMT

Hello,

Not sure how to solve this issue. If I go with Average below count is not big difference but count wise it has a big difference. Is there anyway I can alert that count is flucating.

MinAvg=15.33 MaxAvg=13.00 = DiffAvg : 13.00 - 15.33 = -2.33

WeekNumber	Count
Week-22	16
Week-23	25
Week-24	5
Week-25	6

Regards,

Chandrashekar B