How to get the column total, instead of the row total

[Parul_verma]

Hi team,I am very new to power bi,I have one question regarding the row total. Below is the image for your reference. Like its showing the row total in (Total volume in 1000 kgs) for each item, instead of that I want row total for each month under Total volume in 1000 kgs.As in 36.96 under Nov 2021,35.44 under dec 2021...

[PurpleGate]

Ah then you should try change the ALL to ALLEXCEPT

Measure = 
VAR _TotalVolume = CALCULATE(SUM('Table'[Volume]),ALLEXCEPT('Table','Table'[Item]))
VAR _TotalQuantity = CALCULATE(COUNT('Table'[Item]),ALLEXCEPT('Table'[Month]))

Return 
DIVIDE(_TotalVolume,_TotalQuantity)

[Parul_verma]

Same value for all

[PurpleGate]

Measure = 
VAR _TotalVolume = CALCULATE(SUM('Table'[Volume]),ALLEXCEPT('Table','Table'[Item]))
VAR _TotalQuantity = CALCULATE(COUNT('Table'[Item]),ALL('Table'[Year]))

Return 
DIVIDE(_TotalVolume,_TotalQuantity)

[Parul_verma]

It is showing same values for all the months 

[Parul_verma]

I dont want to show it in the visual, I want the measure as value of 1 sku/total of all sku's for each year

[PurpleGate]

Have you tried playing around with the row subtotal filter in the side panel? Maybe that could help solve your problem?

Or if you meant you wanted the full month total in each category like the image below, you could try using a different visual?

I used Profitbase in this, the free version.