Power BI matrix total incorrect

[Anonymous]

Hello Everyone,

I want to create a measure that returns the Total of the Change (2020-2019) column. The measure I'm using calculates the difference between 2020 and 2019 when all values are present in the row context.  I would like it to do the same when calculating the Total. Presently the Total of -1,349,982 doesn't match the sum of what is in the rows in the matrix.

This is the formula I am using:
Change (2020-2019) =
IF(NOT( ISBLANK(X9[2020 Volume_Sent])),
X9[2020 Volume_Sent] - X9[2019 Volume_Sent]
)

I appreciate your help,

Machel.

[AlB · Accepted solution]

Hi @Anonymous 

Try this measure that uses the one you already have:

Change (2020-2019) TOT =
SUMX ( DISTINCT ( Table1[Month] ), [Change (2020-2019)] )

 where  Table1[Month]  is the first (leftmost) field in your table visual

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

Thanks @AlB ! This got the job done. I really appreciate the help.

Cheers,

Machel