DAX Using Measure Inside Other Measures Messes Up My Date Filters

losamfr17

Board Regular
Joined
Jun 10, 2016
Messages
149
Hi,

I created (got from the web) the following measure to identify all new users (i.e. "Uploaders") starting from Day >= 10/24/21:

Excel Formula:
Measure New Uploaders (Starting wk39):=
(CALCULATE( DISTINCTCOUNT([customer_id]) , 
    FILTER( VALUES( Uploads[customer_id] ) , 
        CALCULATE( COUNTROWS( Uploads ) , 
            FILTER( ALLSELECTED( 'Retail Calendar' ) , [Day (454)] < MIN( 'Retail Calendar'[Day (454)] ) && 
                                                                               [Day (454)] >= DATE( 2021, 10, 24) ) ) = 0 ) ,
             FILTER( 'Retail Calendar', [Day (454)] >= DATE( 2021, 10, 24 ) ) )

It seems to work fine. HOWEVER, when I use the above measure inside a new one such as below, the numbers do not stay consistent:

Excel Formula:
Measure Week New Uploaders:=
CALCULATE( [New Uploaders (Starting wk39)] , FILTER('Retail Calendar', [Previous Week (454)] = "LAST_WTD" ) )

As you can see from the attached picture, the number that should come up on week 40 for Week New Uploaders is 254. Instead it gives me 263 and I can't understand why for the life of me. The ultimate goal is to create measures that track progress of new uploaders at a Week, Month, Season, and Year level.

Any feedback is welcome please.

Thank you.
 

Attachments

  • MrExcel111021.png
    MrExcel111021.png
    17.9 KB · Views: 17

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top