Dax measure to calculate difference between two sorted columns

[Anonymous]

For the table above, I am trying to create a measure that will find the difference between "% of Returns" for (Jan-1 to Apr-1) & "% of Returns" for (Apr-2 to Aug current date). 

But the "% of Returns" is a measure

[

% of Returns = SUM('HJ REturns'[Return Quantity])/CALCULATE(SUM('Dispatch(CSV)'[QTY Pieces]),ALL('HJ REturns'[Reason Code]))

].

Tried many methods but wasn't able to find a solution, and am stuck in this case. It would be really helpful if anyone could help me with the solution.

Thank you in advance.

[Anonymous]

Hi @Anonymous ,

Try to add a date range to filter the % of Returns.

For example,

% of Returns for (Jan-1 to Apr-1) =
SUMX (
    FILTER (
        ALLSELECTED ( 'DateTable' ),
        [Date] >= DATE ( 2022, 1, 1 )
            && [Date] <= DATE ( 2022, 4, 1 )
    ),
    [% of Returns]
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous,

 

 I tried this solution but it doesn't seem to work. It returns a value greater than the value expected.