Forum Discussion

juhoneyighot's avatar
juhoneyighot
Helper III
2 years ago
Solved

DAX Formula using Filter

Hello! I need help on this. I have this matrix table. I have to get the difference confirmed invoices minus the invoices paid. Confirmed and Invoice Paid is a project invoice status under this field...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    juhoneyighot , Try creating three mesures separately

     

    DAX
    Confirmed Amount =
    CALCULATE(
    SUM('invoicedetail'[Amount]),
    'invoicedetail'[invoice.msdyn_projectinvoicestatusname] = "Confirmed"
    )

     

    Invoice Paid Amount =
    CALCULATE(
    SUM('invoicedetail'[Amount]),
    'invoicedetail'[invoice.msdyn_projectinvoicestatusname] = "Invoice Paid"
    )

     

    Outstanding Balance =
    [Confirmed Amount] - [Invoice Paid Amount]

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

juhoneyighot , Try creating three mesures separately

 

DAX
Confirmed Amount =
CALCULATE(
SUM('invoicedetail'[Amount]),
'invoicedetail'[invoice.msdyn_projectinvoicestatusname] = "Confirmed"
)

 

Invoice Paid Amount =
CALCULATE(
SUM('invoicedetail'[Amount]),
'invoicedetail'[invoice.msdyn_projectinvoicestatusname] = "Invoice Paid"
)

 

Outstanding Balance =
[Confirmed Amount] - [Invoice Paid Amount]

  • juhoneyighot's avatar
    juhoneyighot
    Helper III
    2 years ago

    Yeah I thank this is correct. Create 3 measures. Thanks.