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] ) ) )
)
  • ChiRomeu's avatar
    ChiRomeu
    3 years ago

    thanks a lot!

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] ) ) )
)
  • ChiRomeu's avatar
    ChiRomeu
    Helper I
    3 years ago

    thanks a lot!