Forum Discussion

ALDOBES's avatar
ALDOBES
Frequent Visitor
3 years ago

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

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 sh...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

This should work. 

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

Measure = COUNTROWS ( 'DD Log' )

Hope this helps.