Date range issue in slicer

Question

Hi,&nbsp;Below is a measure for bookings between the created date column and the cancelled date column. I need to show the records that fall in the date range which i selected the slicer if any record &nbsp;(created or cancel date) records that falls in the date range should show based on the slicer dates, as the below measure I'm getting all the created dates before the date range i selected&nbsp;Ex-6/19/2023 &amp; 7/30/2023 are not in my range either (created date or cancel date) but the records are still showing. Can anyone please help me to eliminate these records by modifying the query?&nbsp;&nbsp;&nbsp;Bookings = VAR __mindate = MIN('Calendar'[Date])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VAR __maxdate = MAX('Calendar'[Date])VAR __curdate = MAX('report vwRevenueDashboardReport_BookingCard'[Createddate])VAR __created = SWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; __curdate &lt; __mindate,&nbsp; &nbsp; 0,&nbsp; &nbsp; ISBLANK(MAX('report vwRevenueDashboardReport_BookingCard'[Canceldate])),&nbsp; &nbsp; 0,1)VAR __cancelled = SWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; MAX('report vwRevenueDashboardReport_BookingCard'[Canceldate]) &gt;= __mindate&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; MAX('report vwRevenueDashboardReport_BookingCard'[Canceldate]) &lt;= __maxdate,&nbsp; &nbsp; -1,&nbsp; &nbsp; ISBLANK(MAX('report vwRevenueDashboardReport_BookingCard'[Canceldate]))&nbsp; &nbsp; ,1)VAR __result = __created + __cancelledRETURN__result&nbsp;&nbsp;&nbsp;

parry2k · Answer

Suryateza&nbsp;wherever you have 0 in your measure change it to BLANK ()
&nbsp;
👉 Learn Power BI&nbsp;and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

suryateza · Answer

Hi&nbsp;parry2k&nbsp;, Thanks for responing, Still the same result, Thank you

parry2k · Answer

Suryateza&nbsp;Is it possible to share pbix file, and explain which rows shouldn't be showing? Make sure to remove sensitive information before sharing.

parry2k · Answer

Suryateza&nbsp;you need to review this logic, it is returning the value of 1 when the cancel date is blank ()
&nbsp;
    ISBLANK(MAX('Table'[Canceldate]))
    ,1

tezaroyal · Answer

parry2k&nbsp; sent to your email, Please check

Forum Discussion

Date range issue in slicer

5 Replies

Related content

Slicer issue.

Slicers issue

Slicer issue !!

Custom Date Range Slicer

List Slicer Visual Issue