cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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 2
Highlighted
Super User V
Super User V

Re: Total rows

HI @hcze ,

 

 

1.jpg2.JPG

 

 

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)

 

Highlighted
Helper I
Helper I

Re: Total rows

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors