Date Slicer and Date Selector Displaying Different results

[WBscooby]

Hi

I have been trying to filter my data using a date slicer which is linked to a dates table. For the date range selected, I want to then find earliest sales transaction date for each Customer for my calculations.

I looked at various ideas for this and decided to create a MyDate measure to create this and then use it as a filter in my calculated measure. I am getting some unexpected results - when I use the date slicer, the calculation seems to return all information from MyDate and also anything after. When I test using a basic tick box selector, it will filter just on MyDate. Also if I put MyDate in a table it gives the correct date for each customer. I am really confused! Am I missing something in my MyDate code? Any help would be much appreciated!

MyDate =

VAR SlicerDate = MIN(DateCalendar[Date])

VAR MinDiff =

MINX(

FILTER(ALLSELECTED(SalesTransactions),

SalesTransactions[CustomerID] in values(SalesTransactions[CustomerID])

),

ABS(SlicerDate - SalesTransactions[SaleDate]))

RETURN

MINX(

FILTER(ALLSELECTED(SalesTransactions),

SalesTransactions[CustomerID] IN VALUES(SalesTransactions[CustomerID])

&& ABS(SlicerDate - SalesTransactions[SaleDate]) = MinDiff

),

SalesTransactions[SaleDate])

Mycount = CALCULATE(

COUNT(SalesTransactions[SaleID]),

SalesTransactions[NewSale]=1,

FILTER(SalesTransactions,SalesTransactions[SaleDate]= [MyDate])

)

[amitchandak · Accepted solution]

@WBscooby , Not very clear. Try like, for the amount on the first date for each customer

Measure =
VAR __id = MAX (SalesTransactions[CustomerID] )
VAR __date = CALCULATE ( Min(SalesTransactions[SaleDate] ), ALLSELECTED (SalesTransactions ), SalesTransactions[CustomerID] = __id )
CALCULATE ( COUNT(SalesTransactions[SaleID]), VALUES (SalesTransactions[CustomerID] ),SalesTransactions[ID] = __id,SalesTransactions[SaleDate] = __date,SalesTransactions[NewSale]=1 )

[WBscooby]

This worked brilliantly and a lot simpler! thank you!