Plotting Count of Records between dates

[Doylejg3]

Hi There, new to Power BI and struggling with this question.  I'm trying to plot the number of active customers on each date using a line chart, like below:

I have one table I'm working with.  I need to count the distinct number customer ID's when the following criteria are met:

date is >= Cycle Start Date

AND

date is < Cycle End Date

I feel like I'm missing something obvious here.  Thank you for your help!

[SadaqatUllah]

To plot the number of active customers on each date in Power BI, you'll need to first create a calculated column that counts the distinct customer IDs based on the conditions you mentioned. To do this, you can use the DAX formula:

=COUNTD(FILTER(Table, [Date] >= [Cycle Start Date] && [Date] < [Cycle End Date]))

Once you have created this calculated column, you can then create a line chart visual by selecting the Date column as the X-axis and the calculated column as the Y-axis. This will display the number of active customers on each date, based on the conditions you specified.

[Doylejg3]

Thank you for the help!  This definitely helped me get there.  I don't see any "COUNTD" function in Dax but maybe I don't totally understand how to use that.  I ended up using CALCULATE(DistinctCount(FILTER) and that worked for me.