Get measure to filter Date A by the dates already selected by the slider on Date B

[AlexD43]

Hi.

I have a visual showing a number of leads, filtered by lead date, against rows for different products.

Products, Leads and quotes pull through fine, but I want to identify all quotes which have come in in the same period as the leads, not just the quotes on those leads themselves.
(E.G. a: Leads from January. b: Quotes in January (including those quotes on December leads which occurred in January)

I'm trying to set up a pull through of 'Total quotes' filtering 'quoteddate'[fulldate] by the same slider selection as 'leaddate'[fulldate].

Unfortunately I'm not the database manager so I only have access to the measures available or ones I've written in dax in the Desktop App.

If I try to add a separate filter for quoted date to the whole sheet, it will also eliminate leads which haven't been quoted, which I'm trying not to do.

This is what I have which isn't currently working (returns blank column).

Quotes by lead date selector = calculate([Total Quotes],filter(all(QuotedDate[FullDate]),'QuotedDate'[FullDate] = selectedvalue('Lead Date'[FullDate])))

Cheers

[AlexD43]

Hi. Unfortunately I'm not able to create a whole date table to hinge everything off. I'd still need to apply the same principle to the quoted date to a universal date table aswell. As I'm not the data manager I'm only able to apply.

I don't need to filter the quotes by lead date. I just want quote date to equal whatever the date shown in the leaddate filter is.

[amitchandak]

@AlexD43 is lead date is joined with QuotedDate table or better you joined both with date table and filter date table, then both will be filtered on selected Date.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.