How to fix total in matrix

Hi Anonymous 

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.