Forum Discussion

th340385's avatar
th340385
Icon for Helper I rankHelper I
7 years ago
Solved

Weighted Average Interest Rate (by Seller) DAX Formula

Hello,   I am trying to figure out the DAX formula (or best approach) to calculate the weighted average interest rate by loan seller with the ability to add a slicer / filter on vintage. Please let...
Need Help
  • smpa01's avatar
    smpa01
    7 years ago

    th340385used a matrix viz and all my calculations are measures and not calculated column.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
7 years ago

If it is dependent on Loan Bal. Approach could be

Col = Loan Bal * Int. rate 

Weighted Avg = Sum(Col)/Sum(Loan bal)

 

  • JasonSchmidt's avatar
    JasonSchmidt
    New Member
    3 years ago

    Thanks for this! This was the first simplistic option I had come across and it worked perfectly