I wanting help writing out a new measure to sum up information within the below table. Power Bi isn't quite calculating an average for me correctly, so I believe I need one more step in the process. Below are the some example details.
Table Name: FactMarkupApplied
I want a measure that sums up the total markup dollars for a given loan number.
Loan 12345 total markup dollars is $400
Loan 45678 total markup dollars is $800
The reason I want a measure is so I can pull that measure into a visualiation and then take the average markup dollars by loan number. In the above example, the average markup dollars by Loan Number is $600.