Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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...
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)
Same value for all
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
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
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
12 | |
11 | |
9 | |
9 |