Dax function/ report using a validation date

[Do5779]

Hi guys,

I have the following problem, I thought about it for a long time, but I didn't get the right answer. I have a validation date (from... to...) in one table (Tab1) for each ID. The second table is the Id and some further information for example the item which was buyed.

Tab 1:

ID	from	to
1	01/01/2020	01/02/2020
1	01/02/2020	02/02/2020
2	03/09/2022	09/10/2022

Tab2:

ID	Date	item
1	02.01.2020	5
1	09.04.2020	1
1	06.07.2022	4
2	05.09.2022	3

In the report is a filter and e.g. if the filter is at the duration of 01.01.2020 to 06.06.2020 there must be shown item ID 1with item 5 if I set another filter on validation true and if I want to show everything then ID 1 with item 5 and item 1.

In dax I can only call the coloumns but I have to control if the Date is in the duration or not to set the corresponding sign.

I hope you can give me an advice.

Thanks a lot.

[v-kkf-msft · Accepted solution]

Hi @Do5779 ,

Please try these measures.

Measure1 = COUNTROWS( FILTER( 'Table', 'Table'[Date] in VALUES(Dates[Date]) ) )

Measure2 = CALCULATE( [Measure1], ALLEXCEPT('Table', 'Table'[ID]) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.