Forum Discussion

hcze's avatar
hcze
Helper II
6 years ago

Total rows

Hi, Is it possible to get the total rows without creating new category 'Total A+B' (and replicate the data)? 

Thanks,

hcze 

StoreProductt This MonthPrior Month
AProduct 1 2012
 Product 2 3043
 Product 3 32
 Product 4 45
 Product 5 2340
BProduct 1 54
 Product 2 305
 Product 3 35
 Product 4 25
 Product 5 235
Total A+BProduct 1 2516
 Product 2 6048
 Product 3 67
 Product 4 610
 Product 5 4645

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI hcze ,

     

     

     

     

    Create 2 measures

     

    Total A+B (This Month) = CALCULATE(SUM('Table'[This Month]),ALLEXCEPT('Table','Table'[Productt]))
     
     
    Total A+B (Prior Month) = CALCULATE(SUM('Table'[Prior Month]),ALLEXCEPT('Table','Table'[Productt]))
     
    Regards,

    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

    • hcze's avatar
      hcze
      Helper II
      6 years ago

      Thanks Anonymous .

      I would like to be able to show them in one visual if it makes sense. I was thinking somesort of store hierarchy but not sure if it is possible.