Show total of Max

[epelton]

I would like to show the sum of all rows in the grand total of the matrix. Instead, the total is showing the max of all of rows. How do I get the total to show sum of all rows?

[MohammadLoran25]

Hi @epelton ,

You need to iterate through table:

SUMX ( VALUES ( 'Fact_NetRevRpt'[Id] ), [Booked Net Rev] )

If this answer solves your problem, give it a thumbs up and accept it as a solution so the others would find what they need easier.

Regards,

Loran