Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Parul_verma_0-1666249999819.png

 

6 REPLIES 6
PurpleGate
Resolver III
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)

 

 

Parul_verma_0-1666262743747.png

Same value for all

 

PurpleGate
Resolver III
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)
 

It is showing same values for all the months 

Parul_verma_0-1666255991055.png

 

Parul_verma
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

PurpleGate
Resolver III
Resolver III

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

 

PurpleGate_3-1666251684370.png

 

PurpleGate_1-1666251629224.png

 

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.

PurpleGate_4-1666252091801.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.