cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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

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...

6 REPLIES 6
Resolver III

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)`

Frequent Visitor

Same value for all

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

Frequent Visitor

It is showing same values for all the months

Frequent Visitor

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

Resolver III

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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors