Create Measure based on counting all rows up to year and month slicer

[Anonymous]

I have Year Slicer and Month Slicer.

I want to count all rows up to what the Year and Month slicer is selected.
For example, I have ID and my data starts from 01-01-2020 to current month which is November 2022.

What i want to achieve is that when 2022 Year slicer is selected and April Month Slicer is selected, I want to count all rows or records from January 2020 to April 2022.
How can I write dax to achieve this?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below sample can provide some ideas on how to create a solution for your datamodel.