Cumulative Measure issue with Direct Query Mode

[Anonymous]

Hi Expert

How do you get around the following issue when writing cumulative measures in Direct Query Mode....

See image

Here are the Measures in Question - Measures 

1.

Cumulative Today =

CALCULATE (

[Total Sales],

FILTER (

ALLSELECTED ( FACTSalesOrderTable ),

FACTSalesOrderTable[created_at_sales_flat_order] <=max ( FACTSalesOrderTable[created_at_sales_flat_order] )

)

)

2.

Cumulative Previous Weeks =

CALCULATE(

[Previous Weeks],

FILTER(

ALLSELECTED('FACTSalesOrderTable'[created_hour]),

ISONORAFTER('FACTSalesOrderTable'[created_hour], MAX('FACTSalesOrderTable'[created_hour]), DESC)

)

)

3.

Cumulative Previous Year =

CALCULATE(

[Previous Year],

FILTER(

ALLSELECTED('FACTSalesOrderTable'[created_hour]),

ISONORAFTER('FACTSalesOrderTable'[created_hour], MAX('FACTSalesOrderTable'[created_hour]), DESC)

)

)

[amitchandak · Accepted solution]

@Anonymous , do some of these dates have timestamp, if that is not needed in the visual create date without timestamp and use those in meausre.Or Join Dates with the date of date table and try using date of date table in place of these dates in cumulative logic

[Anonymous]

Hi Amit Checking.....And how would the dates from the date table work?