Sum Value no included in matrix

[ZLee21]

Occupancy Test = sum('Merge1'[OCC total])

I want this "total" value for Occupancy test to not appear. My other calculations are being affected by the 474.29%. Can someone help.

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[ZLee21]

Now I'm having the issue in these 2 columns in the matrix. I want the sum of Revenue Increase and Average of %

[tamerj1]

Hi @ZLee21 

to blank out the total you may use

Occupancy Test =
IF ( HASONEVALUE ( 'Table'[DateTime - Copy] ), SUM ( 'Merge1'[OCC total] ) )

[ZLee21]

Thank you, exactly what I needed