Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Continuous Count

Target Results:  Is to have a count of memberships which will give me a total number within a selected period of time. The membership terms are for 1 year. - The goal is to be able to drilldown fro...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,


I'm not so sure for your data structure, please share a pbix file with some sample data so that we can test on it.

 

In addition, you can also try to use following measure if it works:

ActiveMembershipCount =
VAR _date =
    ALLSELECTED ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        COUNT ( Contracts[members] ),
        FILTER (
            ALLSELECTED ( Contracts ),
            Contracts[fr_datetime] <= MAXX ( _date, [Date] )
                && Contracts[to_datetime] >= MINX ( _date, [Date] )
        ),
        VALUES ( Contracts[members] )
    )

Regards,

XIaoxin Sheng