DAX question using two date columns and filtering

[_power_bi]

I am currently pulling blanks when I know there is data. Something is wrong with my DAX but I'm not sure. Any help is appreciated

I need a running total of the transfers[quantity] field to put in a line chart by week or month. The xaxis on the line chart is a date from the dim_date table. 

date dimension= dim_date[date]

fact table= transfers

fact table date field= transfers[due_date] : this has an inactive relationship to the date dimension

I need to filter my transfers table to show the sum of transfers[quantity] (not YTD, but running total).

Filters:  transfers[direction]= "out"

simplefilter= 0

I must be able to filter using active relationships to my dim_facility table and dim_device table. 

VAR MaxDate = MAX('dim_date'[date])

VAR MinDate = Min('dim_date'[date])

RETURN

  CALCULATE(

    SUM('Transfers'[QUANTITY]),

    'Transfers'[Direction] = "Out",

    USERELATIONSHIP(Dim_Date[Date], 'Transfers'[Due_Date]),

    FILTER(

        ALLEXCEPT('Transfers', dim_Facility[contract]),

        'Transfers'[Due_Date] <= MaxDate

        && 'Transfers'[Due_Date] >= MinDate

        && 'Transfers'[SimpleFilter] = 0

    )

)

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

=CALCULATE(SUM('Transfers'[QUANTITY]),'Transfers'[Direction] = "Out",'Transfers'[SimpleFilter] = 0,USERELATIONSHIP(Dim_Date[Date], 'Transfers'[Due_Date]),datesbetween(Dim_Date[Date],minx(all(Dim_Date),Dim_Date[Date]),max(Dim_Date[Date])))

[parry2k]

@_power_bi not sure what you are trying to do but try this measure and go from there

  CALCULATE(
    SUM('Transfers'[QUANTITY]),
    'Transfers'[Direction] = "Out",
    'Transfers'[SimpleFilter] = 0,
    USERELATIONSHIP(Dim_Date[Date], 'Transfers'[Due_Date]),
    FILTER(
        ALL ( Dim_Date[Date] ), 
        Dim_Date[Date] <= MAX ( Dim_Date[Date] )
     
    )
)