Dax Measure - Ignore Selectedvalue[date], then filter [date2] on selectedvalue[date]

Question

I have a measure similar to the below (context changed)However it doesn't work, it just returns all rows of the table by the selectedvalue[ReceivedDate] still.I need it to create a linegraph showingline A: the total number of 'sausages' received in a period&nbsp;line B: the total number of 'sausages' 'reallyratherbadlyburnt' in a periodDead Sausages (Use Received Date as Cooked Date) =VAR&nbsp;SelectedFromDttm&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;SELECTEDVALUE&nbsp;(&nbsp;'DD&nbsp;Log'[Received Date]&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;'DD&nbsp;Log'&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;ALL&nbsp;(&nbsp;'DD&nbsp;Log'[ReceivedDate]&nbsp;),&nbsp;'DD&nbsp;Log'[CookedDate]&nbsp;=&nbsp;SelectedFromDttm&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'DD&nbsp;Log'[SausageStatus]&nbsp;=&nbsp;"reallyratherbadlyburnt"&nbsp;&nbsp;&nbsp;&nbsp;)Also Tried&nbsp;Dead Sausages (Use Received Date as Cooked Date) =VAR&nbsp;SelectedFromDttm&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;SELECTEDVALUE&nbsp;(&nbsp;'DD&nbsp;Log'[Received Date]&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;'DD&nbsp;Log'&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;ALL&nbsp;(&nbsp;'DD&nbsp;Log'[CookedDate]&nbsp;),&nbsp;'DD&nbsp;Log'[CookedDate]&nbsp;=&nbsp;SelectedFromDttm&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'DD&nbsp;Log'[SausageStatus]&nbsp;=&nbsp;"reallyratherbadlyburnt"&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;and&nbsp;Dead Sausages (Use Received Date as Cooked Date) =VAR&nbsp;SelectedFromDttm&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;SELECTEDVALUE&nbsp;(&nbsp;'DD&nbsp;Log'[Received Date]&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COUNTROWS&nbsp;(&nbsp;'DD&nbsp;Log'&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;ALL&nbsp;(&nbsp;'DD&nbsp;Log'),&nbsp;'DD&nbsp;Log'[CookedDate]&nbsp;=&nbsp;SelectedFromDttm&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'DD&nbsp;Log'[SausageStatus]&nbsp;=&nbsp;"reallyratherbadlyburnt"&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;Same results.&nbsp;Please help.

lbendlin · Answer

Might be easier to help&nbsp; if you could provide sample data and show the expected result.

ashish_mathur · Answer

Hi,
This should work.&nbsp;

Create a Calendar Table
Create a relationship (Many to One and SIngle) from The Cooked Date column to the Date column of the Calendar Table
Create a Date slicer from the Calendar Table and select any date/date range
Write this measure

Measure =&nbsp;COUNTROWS&nbsp;(&nbsp;'DD&nbsp;Log'&nbsp;)
Hope this helps.

Forum Discussion

Dax Measure - Ignore Selectedvalue[date], then filter [date2] on selectedvalue[date]

2 Replies

Related content

Selectedvalue on date slicer

Selectedvalue date between two dates

DAX: SELECTEDVALUE with Dates

SelectedValue and Dates

Measure with SELECTEDVALUE for Calendar date doesn't work in visual if Date is set as Date Hierarchy