How to fix total in matrix

[ChristoNindyo]

Hello experts,

May I ask how to fix total in this table ? 

Values here I used measure:

_0_Visits2_Planned = IF(ISBLANK(VW_FACT_VISIT[_Planned2_TotalVisits]) || VW_FACT_VISIT[_Planned2_TotalVisits] = 0, 1, 0)

_Planned2_TotalVisits = IF(ISBLANK(SUM(VW_FACT_VISIT[_Visits_Planned])), 0, SUM(VW_FACT_VISIT[_Visits_Planned]))

_Visits_Planned = IF(VW_FACT_VISIT[VISIT_TYPE]="Planned",1,0)

Thank you!

[v-xianjtan-msft · Accepted solution]

Hi @ChristoNindyo 

Thanks Chew_WenJie for your positive response and great answer.

Agree with Chew_WenJie. The SUMX function iterates through each unique value in the 'Primary Resources TMR' column and applies IF logic to each value and then sums the results. This ensures that in the context of totaling rows and columns, the measure correctly calculates the value for each cell and summarizes it.
Modify your measure [_0_Visits2_Planned] as follows:

_0_Visits2_Planned = 
SUMX(
    VALUES(VW_FACT_VISIT[Primary Resources TMR]),
    IF(
        ISBLANK(VW_FACT_VISIT[_Planned2_TotalVisits]) || VW_FACT_VISIT[_Planned2_TotalVisits] = 0,
        1,
        0
    )
)

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chew_WenJie]

The total is incorrect because you are using the IFELSE measure. Try creating another measure that references the existing DAX measure. For example:

= SUMX(VALUES('Primary Resources TMR'), _Visits_Planned)

This approach ensures the calculation correctly aggregates the values across all rows.