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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ssze
Helper II
Helper II

Column total - not the sum i'm after

Hi all!

 

I am working on a production total based on work day (column 1) and production target (tons/day) (column 2)

so as shown below,

Jan would be 18 days x 273t/day = 4900t/day (column 3)

 

Each row in column 3 is calculated correctly, but I am wanting the column total to be the sum of each row of column 3 (total = 69900t).

 

ssze_0-1669255016759.png

 

Thanks heaps!

Silvia

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@ssze First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks heaps @Greg_Deckler  - I think I can see the concept! I had a bit of a play but still struggle to get it to work because my workday column is a sum from a powerBI calendar function plus an extra calculated column (i.e. from a separate table). I am struggling to get the 2 to link... do you have some examples of working this through 2 separate but related tables?

(also, as per your suggestion, voted for the idea - hope that goes through)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors