Matrix table subtotal problem

[ChiRomeu]

Dear Members,
 Could you please kindly help to solve the following problem? see the picture
 i would like that the sum celds are igual to subtotal of the matrix.

Best regards

[tamerj1 · Accepted solution]

Hi @ChiRomeu 

please try

Count =
SUMX (
    CROSSJOIN (
        SUMMARIZE ( Coutry, Country[Continent], Country[City] ),
        VALUES ( Company[Company] ),
        VALUES ( Products[Product] ),
        VALUES ( Services[Service Type] )
    ),
    COUNTROWS ( CALCULATETABLE ( VALUES ( Customers[Customer] ) ) )
)

[tamerj1 · Accepted solution]

Hi @ChiRomeu 

please try

Count =
SUMX (
    CROSSJOIN (
        SUMMARIZE ( Coutry, Country[Continent], Country[City] ),
        VALUES ( Company[Company] ),
        VALUES ( Products[Product] ),
        VALUES ( Services[Service Type] )
    ),
    COUNTROWS ( CALCULATETABLE ( VALUES ( Customers[Customer] ) ) )
)

[ChiRomeu · Accepted solution]

thanks a lot!