- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Getting 0 for grand total on a created Measure
Hello Everyone,
I feel like this is an easy fix but im abselutely stumped.....
I have seen a couple of forums for items similar to this but they were slightly different/specific and i wasnt sure how to work those methods into my situation.
I have created a couple of measures.
1. is to caclualte Points times Qty of items.
While these formula gave me proper results in the view i dont get a grand total for the view it just says 0
This is where i cant seem to figure out how to get Grand Totals. Please Help =]
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Good Morning Everyone,
Thank you for your feedback and assistance on this one.
Just wanted to give a shout out to @tamerj1 .
I found an old post he was on and the solution below worked perfectly for what i was needing.
I was able to multiple 2 columns from different tables and get grand totals for my new field categories.
Thought i would share it in case it can help anyone else in the future. Thanks again!
NewMeasure = SUMX ( Table1, VAR Name = Table1[Name] VAR Value1 = Table1[Value] VAR Value2 = MAXX ( FILTER ( Table2, Table2[Name] = Name ), Table2[Value] ) RETURN Value1 * Value2 )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Good Morning Everyone,
Thank you for your feedback and assistance on this one.
Just wanted to give a shout out to @tamerj1 .
I found an old post he was on and the solution below worked perfectly for what i was needing.
I was able to multiple 2 columns from different tables and get grand totals for my new field categories.
Thought i would share it in case it can help anyone else in the future. Thanks again!
NewMeasure = SUMX ( Table1, VAR Name = Table1[Name] VAR Value1 = Table1[Value] VAR Value2 = MAXX ( FILTER ( Table2, Table2[Name] = Name ), Table2[Value] ) RETURN Value1 * Value2 )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@BobSled 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
Follow on LinkedIn
@ 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!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please see this video. You'll need to use SUMX with VALUES or SUMMARIZE in your measure.
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-17-2024 04:33 AM | |||
05-30-2025 03:52 AM | |||
07-03-2025 02:24 AM | |||
06-26-2025 01:24 AM | |||
06-03-2025 08:36 AM |
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |