Forum Discussion

GuiBu's avatar
GuiBu
New Member
3 years ago

SUM rows independently

Hi all,

 

I am kind of new to power bi and I've been able to google/youtube my way through most of what I need (calculating Average Daily, Running Totals, Forecasting, etc.).

The question I have is if there is an easy way for me to SUM "rows independently" so that when I remove such a row instead of recalculating it just add whichever row total I previously had.

 

- I have a table with "ITEM 1" and "ITEM 2" all the values are measures:

- When I remove the row "ITEM" it recalculates:

- What I need instead is for PB to add the "ITEMs" totals:

 

I hope I explained my issue correctly and I appreciate any help I can get.

 

G

 

 

 

2 Replies