topic Removing a slicer interaction while still using the slicer value in DAX Commands and Tips

Removing a slicer interaction while still using the slicer value

ktg2019 — Wed, 15 Jan 2025 20:42:25 GMT

In my report, a user will select a date using a date between slicer and we're only using the minimum date selected.

This date can be any day of the week. I want to show the sales numbers for the entirety of that week. For example, if a user selects a Wednesday, I want to show the values for Sunday through Saturday of that week.

I have tried several remedies, but it seems like I either show the days leading up to the selected day or the days after the selected day-- I have not been able to see the entire week at once.

One attempt of a calculation was

CALCULATE(sum(*redacted sales table info*),ALL('vw_D_Date'[date_value]),FILTER(*redacted sales table*,[MinimumSelectedDate]))

where MinimumSelectedDate = FIRSTDATE('vw_D_Date'[date_value])

Any suggestions on how to solve this?

Re: Removing a slicer interaction while still using the slicer value

Anonymous — Thu, 16 Jan 2025 07:41:52 GMT

Hi, ktg2019

You can try the following method to achieve your need.

Measure:

Sales = VAR _quarterSlicer = SELECTEDVALUE(Slicer[Quarter]) VAR _quarterSales = SELECTEDVALUE(Sales[Quarter]) VAR _yearSlicer = SELECTEDVALUE(Slicer[Year]) VAR _yearSales = SELECTEDVALUE(Sales[Year]) VAR _result = CALCULATE(SUM(Sales[Sales]),FILTER(Sales,_yearSales = _yearSlicer && _quarterSales = _quarterSlicer )) RETURN IF(_yearSales = _yearSlicer && _quarterSales = _quarterSlicer,1)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Re: Removing a slicer interaction while still using the slicer value

sjoerdvn — Thu, 16 Jan 2025 10:55:14 GMT

Why not create a slicer with week numbers? Just add a column to your date dimension with year and weeknumber. You could also create a column for your slicer that includes the dates e.g "2025 WK1 (30-12-2024 - 05-01-2025).