count active elements items between 2 dates

Hi BigLo ,

 

Few questions:

• what is the definition of ACTIVE elements between 2 dates? you haven't mentioned it.
• The screesnhot of the data doesn't help us if we want to try it at our end. Please attach sample data as a file attachment so that it can easily be imported to Power BI.

Thanks,

Pragati

Hi BigLo ，

I created a sample pbix(see attachment) for you, please check whether that is what you want.

1. Create a date dimensio table

Date = CALENDAR(MIN('Table'[Start]),MAX('Table'[End]))

2. Create a measure to get the count of the active elements

Active items = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Id] ),
    FILTER (
        'Table',
        'Table'[Start] >= SELECTEDVALUE ( 'Date'[Date] )
            && 'Table'[End] >= SELECTEDVALUE ( 'Date'[Date] )
    )
)

3. Create a line chart( Axis: Date(From date dimension table)  Values: Measure)

Best Regards