Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Matrix not summing my values

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.

 

option 2 horizontal.PNG

1 ACCEPTED SOLUTION
7 REPLIES 7
jtownsend21
Responsive Resident
Responsive Resident

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

Anonymous
Not applicable

I am using the matrix. but cannot share data.

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
Not applicable

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.

 

option 1 vertical.PNG

Anonymous
Not applicable

Great! glad you found a solution. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.