So I am curious as to whether there is something about the measure in the matrix that prevents the total rows from working. It gives the numbers just fine on the rows as it should but when it comes to the totals they are blank. I have checked the settings to ensure the totals are toggled on. Is there a battery way to approach the below formula to make the totals work as expected?

The measure is

Anticipated Tuition =

IF(

HASONEVALUE(projections[Projection Category]),

SWITCH(

TRUE(),

VALUES(projections[Projection Category])= âUG Civilianâ, âKey Measures - Projectionsâ[Projections] * (429 * 3),

VALUES(projections[Projection Category])= âUG Militaryâ, âKey Measures - Projectionsâ[Projections] * (250 * 3),

VALUES(projections[Projection Category])= âGR Civilianâ, âKey Measures - Projectionsâ[Projections] * (714 * 3),

VALUES(projections[Projection Category])= âGR Militaryâ, âKey Measures - Projectionsâ[Projections] * (599 * 3)))