Require a DAX measure for capturing transactions based on dynamic user date selection

[Sunila]

I have a vendor transaction table and trying to select only those transactions where Transaction date (VendTrans.TransDate) is equal or less then the user selected date(lets call it Selected Bal Date).

Once this condition met, need to check if those transactions are settled or not:

  - if it is settled(LastSettlementdate is not null) we need to further add the condition based on when it was settled:

• If the settlement date (VendTrans. SettlementTransDate) is lower then the Selected Bal Date , we need to consider the whole amount (VendTrans.AmountMST)
• If the settlement date (VendTrans. SettlementTransDate) is higher or equal then Selected Bal Date, we need to subtract the settle amount from the total amount (VendTrans.AmountMST- VendSettlement.SettleAmountMST).                                        The sum of the transactions obtained  with the above query  gives us the Amount Due Balance.

  Could someone assist in creating a DAX measure ( not column) for the above condition?

[some_bih]

Hi @Sunila if possible, provide file with data and expected output for example

[Sunila]

Thank you.@some_bih 

 I have managed to create the DAX and it seems to be working now.