Slicer min and max selection

Anonymous — Mon, 01 May 2023 06:12:23 GMT

Hi all,
I am using the slicer to select hours from 0 to 23, and whatever that is selected between the slicer is selected working hours and rest should be considered as not working hours, and based on these i need to do value a - b for selected hours and assumed value c - d for non selected hours

for this when I tried MIN( table[column]) and MAX(table[column]) is not working everywhere, it is working on card and table but not on calculations
Based on the slicer selection if i try selecting in checkbox like below:

I am getting 0 and 23 as not working hour and rest all as working, since min and max is taking 0 and 23 and not the slicer selected value.
Kindly help how to select the ranges dynamically and not 0 or 23 as min and max

Re: Slicer min and max selection

Anonymous — Tue, 02 May 2023 02:49:32 GMT

Hi Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a measure.

_slicermin = MINX(FILTER(ALLSELECTED('Table'),'Table'[Hour]),'Table'[Hour])

_slicermax = MAXX(FILTER(ALLSELECTED('Table'),'Table'[Hour]),'Table'[Hour])

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

topic Slicer min and max selection in DAX Commands and Tips

Slicer min and max selection

Re: Slicer min and max selection