I have a list of credit card transaction debit attempts for sales and want to find the % total of transactions that failed on the first attempt. (Each sale can have up to three debit attempts on consecutive days if the previous day’s debit attempt failed.)
For example, below shows Sale ID 3340926 failed on the first attempt on July 1st but succeeded on the second attempt on July 2nd.
My measure needs to look at each distinct Sale ID and see if the transaction record with the lowest date for that unique sale ID failed or was processed.
I’ve tried all morning but am getting nowhere.
Sample data attached.
Sample Data.pbix (535.4 KB)