Transaction log, totals by CaseID, calculate difference on CaseID level

[Anonymous]

Sample file

Hi, I have Trasaction log for invoices of different type and payments coming in. I need to see if payments per CaseID are bigger then Invoices for type 1, and for how much. And I'm stuck. Pls help. Thanks

[v-danhe-msft]

Hi @Anonymous,

Based on my test, you could refer to below measures:

Payment = CALCULATE(AVERAGE(Table1[Amount]),FILTER('Table1','Table1'[CaseID]=MAX('Table1'[CaseID])&&'Table1'[TypeOfTransaction]="PAYMENT"))

Invoice = CALCULATE(AVERAGE(Table1[Amount]),FILTER('Table1','Table1'[InvoiceType]=1&&'Table1'[TypeOfTransaction]="INVOICE"))

Difference = [Payment]-[Invoice]

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[Anonymous · Accepted solution]

Thanks for effort, solution to problem is at this link Final Word On Measure Totals.

[BobBI]

would you be able to share some sample data to work this out ?

[Anonymous]

link is above tekst.