Forum Discussion
ianwuk
Helper III
Helper IIIHow to sum values horizontally in a table?
Hello. I have sales data for number of products sold per staff member that looks like this, with the totals being calculated vertically, how can it be calculated horizontally as well? My data...
You can go to Format pane of your table, and there should be an option for grand total that you can turn it off to remove Total. As for displays 0, you can write the following:
Sales Total =
VAR temp = SUMX(Sales, Sales[Hat] + Sales[Scarf] + Sales[Gloves])
RETURN IF(temp = BLANK(), 0, temp)
You can create a measure like this:
Total = SUMX(Sales, Sales[Gloves] + Sales[Hats] + Sales[Scarfs])
Then simple drag it to your table
ianwukHelper III
Helper IIIThanks very much for this, Anonymous. Let me try it out and see.