DAX Help with VAR measure statement

Question

I have a table like the one shown below. I need to create a measure that can dynamically show totals based on a selected date.&nbsp;&nbsp;Tables:&nbsp;1. Date table2. Orders&nbsp;Table Structure:Order&nbsp; &nbsp; &nbsp; &nbsp;Orig .Amount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Current Amount&nbsp; &nbsp; &nbsp; &nbsp; Inv Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Inv Paid1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/2/2019&nbsp; &nbsp; &nbsp; &nbsp; 1/5/20192&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1/10/2019&nbsp; &nbsp; &nbsp; 1/20/2019&nbsp;I currently have the date field from my date table as a slicer. And have a var statement below that will calculate the total based on the selected date and the inv date. However, it does not take into account the balance due column. So if my&nbsp;Selected Date is &gt; Inv Date but &lt; the Paid Date, it needs to sum the Orig Amount, as it has not been paid yet. If the&nbsp;Selected date is &gt;&nbsp;Inv Paid it needs to sum the Current Amount.&nbsp;&nbsp;Example. I selected 1/15/2019. For order 1, the selected date &gt; Paid Date, so i should calculate as 2. For order 2 the selected date is &lt; Paid Date so this should calculate as the orig. amount of 20. How can i write a measure that will equal 22?&nbsp;

dax · Accepted Answer

Hi thampton,If you want to calculate total value based on date, you could try below measure to see whether it works or nottotal =
CALCULATE (
    SUM ( 'order'[orig.amount] ),
    FILTER (
        'order',
        'order'[inv date] &lt;= SELECTEDVALUE ( 'date'[Date] )
            &amp;&amp; 'order'[inv paid] &gt;= SELECTEDVALUE ( 'date'[Date] )
    )
)
    + CALCULATE (
        SUM ( 'order'[current amount] ),
        FILTER ( 'order', SELECTEDVALUE ( 'date'[Date] ) &gt; 'order'[inv paid] )
    )Best Regards,Zoe Zhi&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

DAX Help with VAR measure statement

1 Reply

Related content

PowerBI measure IF statement

Measure IF statement for each row

If Statement in Measure

DAX Measure with Nested IF Statements

Help with optimizing DAX measure - Income statement