Forum Discussion
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...
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 you mean I will make 3 measures on this?
Yeah I thank this is correct. Create 3 measures. Thanks.