Forum Discussion

wrwillits's avatar
wrwillits
Helper III
2 years ago
Solved

Measure will not total in Matrix Table

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?
Need Help
  • wrwillits's avatar
    wrwillits
    2 years ago

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

     

    Also, thanks @parry2k 

4 Replies