topic Re: Getting 0 for grand total on a created Measure in DAX Commands and Tips

Getting 0 for grand total on a created Measure

BobSled — Thu, 18 May 2023 21:52:17 GMT

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.

Spec Point QTY = MIN('SageProductMaster'[Points]) * SUM('spec_credits'[qty_0])

2. is to use the previous measure(Spec Point QTY) to calculate total points times Dollars

Spec Points = [Spec Point QTY]*SUM(spec_credits[untaxed])

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 =]

Re: Getting 0 for grand total on a created Measure

ppm1 — Thu, 18 May 2023 22:22:26 GMT

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

Re: Getting 0 for grand total on a created Measure

Greg_Deckler — Fri, 19 May 2023 01:13:08 GMT

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

Re: Getting 0 for grand total on a created Measure

BobSled — Fri, 02 Jun 2023 15:41:11 GMT

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
)