How to create a measure that filter line by line in same colum by a data set

[Anonymous]

Hi guys!

I have three tables that i used to build of the measures.

Table  1 (Stores)

Field - First date of sales

Field - First ninety days ( First date of sales + 89)

Field - CNPJ (Code Store)

Table 2 (Ticket)

Field - Id Ticket 

Field - created date

Field - CNPJ (Code Store)

Table 3 ( CNPJ Dimension)

Field - Distinct (CNPJ)

I need that a measure that make calcule with paremeters of date.

Example:

Store 1, First date of Sales (23/12/2020),  First ninety days (22/03/2021)

Store 2,  First date of Sales (03/12/2020),  First ninety days (02/03/2021)

I want that measure make distinct count of tickets, where the result it s total of ticket (store 1 + store 2). It s possible?

I know that a calculated column would be possible, but I want to measure it.

[edhans]

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.