Blank Weighted Average Total

[JTitor11]

Hello,

I'm looking to show the weighted average of interest rates. I'm getting a blank because I am using the selected values function to help filter data, but I can't figure out how to work around this. I have a similar formula for balances, but this is done using a simple average rather than a weighted average for the total. 

Table:

Current CD WAR Measures:

I read in a previous post that the IF(Hasonevalue()) is a great way to solve this, but I can't find the solution. In this instance, I need the CD WAR total in the table to be approximately 4.47% = ((32.3*4.51%)+(44.6*4.64%)+(79.2*4.35%))/(32.3+44.6+79.2)

Any help would be greatly appreciated.

[JTitor11 · Accepted solution]

I solved this by using the quick measure. I'm sorry for inconveniencing anyone.