Distinct Count with filter plus previous week returning no values

[mcomsto]

I am trying to create a previous week count of activities like below, but I cannot get any values to return after applying the date filter.  I'm new to DAX so it mostly likely a simple issue, any help is greatly appreciated.

Consented Previous Week = CALCULATE(DISTINCTCOUNT(CareActivityData[PersonID]), FILTER(CareActivityData,CareActivityData[Consent Count] = 1),
FILTER(All('Date'[WeekNum]),'Date'[WeekNum]= MAX('Date'[WeekNum])-1 ))

[Zubair_Muhammad]

HI @mcomsto

Try replacing ALL with ALLSELECTED

Consented Previous Week =
CALCULATE (
    DISTINCTCOUNT ( CareActivityData[PersonID] ),
    FILTER ( CareActivityData, CareActivityData[Consent Count] = 1 ),
    FILTER (
        ALLSELECTED ( 'Date'[WeekNum] ),
        'Date'[WeekNum]
            = MAX ( 'Date'[WeekNum] ) - 1
    )
)

[mcomsto]

Thank you for your reply, but that did not seem to work either.

[mcomsto]

any other ideas?

[Zubair_Muhammad · Accepted solution]

@mcomsto

Hmm...

Try this one

Consented Previous Week =
CALCULATE (
    DISTINCTCOUNT ( CareActivityData[PersonID] ),
    CareActivityData[Consent Count] = 1,
    FILTER (
        ALLSELECTED ( 'Date'[WeekNum] ),
        'Date'[WeekNum]
            = MAX ( 'Date'[WeekNum] ) - 1
    )
)

[mcomsto]

thank you.