Matrix not summing my values

[Anonymous]

I have this formula and the matrix is not summing in the totals.

Average Holding Period = IF(FIRSTNONBLANK(Capex[Fully E. N. Leases & A. Year],TRUE()) = YEAR(TODAY()), MONTH(TODAY()),  IF(LASTNONBLANK(Capex[Fully E. N. Leases & A. Year], TRUE())  = LASTNONBLANK(Capex[Built Date],TRUE()) ,     12 - (month(average(Capex[OTHVR Actual Date])))   ,    12  ))

They are divided in years, but for some reason it displays 12 in the grand total.

[jtownsend21]

Can you share some sample data and what visualization you are using? 

[Anonymous]

I am using the matrix. but cannot share data.

[jtownsend21]

Without sample data I am not sure how to help.

Please see this post: 

How to Get Your Question Answered Quickly - Microsoft Power BI Community

[Anonymous]

maybe this can help? average holding period subtotal is not adding up. the dax has if statement and average of date, I dont know how thats affecting this.

[jtownsend21]

Check out this post. It may provide some guidance. 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

[Anonymous · Accepted solution]

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

this one did work

[jtownsend21]

Great! glad you found a solution.