Total rows

[hcze]

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	12
	Product 2		30	43
	Product 3		3	2
	Product 4		4	5
	Product 5		23	40
B	Product 1		5	4
	Product 2		30	5
	Product 3		3	5
	Product 4		2	5
	Product 5		23	5
Total A+B	Product 1		25	16
	Product 2		60	48
	Product 3		6	7
	Product 4		6	10
	Product 5		46	45

[harshnathani]

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]

Thanks @harshnathani .

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.