Measure Help!

[gaurav-narchal]

Dear All

I am seeking your help to show “error” on all Invoices in PowerBi if Payment or Batch No is updated twice in the same Invoice number.

So basically “Per Invoice”  Payment & Batch No should be always updated once else it should show as an Invoice error.

Order Reference and Account Number can be shown multiple times per Invoice. Can I achieve this using a Measure?

Please click here to access the sample report.

Thank you in advance.

Gaurav

[PaulDBrown · Accepted solution]

This is as far as I've got:

What criteria do you wish to identify the valid row for each duplicate (which you have formatted as green)?

I've attached the sample PBIX file for you