Count rows filtered table

Hi Naomig2088 

I would like to apologize for the belated reply.

I modified my sample.

Date table:

Employee table:

Then I ran the following test:

1. Create several measures as follow

Measure = IF(SELECTEDVALUE('Table'[Date]) >= MIN('Date'[Date]) && SELECTEDVALUE('Table'[Date]) <= MAX('Date'[Date]), 1, 0)

count = COUNTX(FILTER('Table', 'Table'[Date] >= MIN('Date'[Date]) && 'Table'[Date] <= MAX('Date'[Date])), 'Table'[employee])

2. Put the measure into the filter so that the visual only shows data where the measure is equal to 1.

The role of the slicer is to filter out the previous 12 months or the previous 6 months of data.

Is this the result you expect?

If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Please remove any sensitive data in advance.

Best Regards,
Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.