Calculate Change from Previous Week Not Working

[andybamber]

Hello All,

I have a small issue with my report.

What i am trying to show is the change in headcount from previous week. i found this dax measure and it works when a user selects a specific date:

Change from Previous WK =

VAR lastWeekAmount =

    CALCULATE (

        DISTINCTCOUNT( SNAP_DWH_RES_RESOURCE[resource_key] ),

        FILTER (

            ALL ( DATE_DIMENSION ),

            DATE_DIMENSION[Week of Year]

                = MIN ( DATE_DIMENSION[Week of Year] ) - 1

        )

    )

RETURN

     DISTINCTCOUNT( SNAP_DWH_RES_RESOURCE[resource_key] ) - lastWeekAmount

So if the user selects December 1 from the line chart the Headcount in the table changes to reflect correctly and the Change from Previous Week is calculated correctly... previous week was 763

However, when no specific date is selected the table correctly shows the latest headcount of 767 but DOES NOT show the change from previous week which was 3 (if the user selects December 8 specifically it does work). I presume its because the measure cannot calculate as a specific date is not in focus... but i cant seem to overide...

So, how do i modify the measure (or even create another measure) which will correctly show latest headcount and change from previous week when a specific date isnt selected?

Thanks,

Andy

[lbendlin]

use HASONEVALUE() , HASONEFILTER() or some of the other checks to figure out if the user has made a selection. If not, precompute the result based on the max date.