Forum Discussion

ChiRomeu's avatar
ChiRomeu
Helper I
3 years ago
Solved

Matrix table subtotal problem

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's avatar
    tamerj1
    3 years ago

    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] ) ) )
)

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    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] ) ) )
)