Forum Discussion

hcze's avatar
hcze
Icon for Helper II rankHelper 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  Store Productt   This Month Prior Month A Product 1   20 1...
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
Icon for Helper II rankHelper 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.