Measure will not total in Matrix Table

[wrwillits]

I've created a simple measure that compares two columns in two differnt tables to see if they are equal or not.

m.RetirementEvent =

IF(

    Average(RetirementAgeTable[Age]) = Average('Fleet Age Forecast'[Future Age]), 1, 0

)

I have added the "m.RetirementEvent" measure to a Matrix table and it works great for the individual cells, but it will not total the rows or the columns. 

The idea is to allow the user to select the retirement age (the Age Slicer), which will then trigger the Matrix table to update and show the year that each aircraft will retire. I then want to use the totals by year to create a retirement line chart showing the total Volume of retirements per year. 

The "RetirementAgeTable[Age]" comes from the user selected Age Slicer, and the "Fleet Age Forecast'[Future Age]" comes from a fleet table that includes all the calculated ages of the aircraft from today out to 30 years into the future. 

I have tried numerous ways to write the measure, but I can't get the Matrix to total the numbers. What am I doing wrong?

[wrwillits]

Thanks.

[Greg_Deckler]

@wrwillits First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

Thanks @parry2k 

[wrwillits · Accepted solution]

Thanks Greg. I will do some reading and figure this out. I'll also vote for your idea.

Also, thanks @parry2k 

[parry2k]

@wrwillits Referring to @Greg_Deckler - he is the master to answer on this subject. Cheers!