Forum Discussion

fbarry's avatar
fbarry
Frequent Visitor
6 years ago
Solved

SUMX issue

Hi All,   I'm having an issue trying to get a SUMX expression to return the expected results, and after many hours of toil I am now officially stumped.  Ultimately, am trying to create a measure t...
sumx
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Please try this one.  It gets the same results on rows and correct total.  This is the more logical way I should have written it in the first place.

     

    New SUMX =
    SUMX (
    SUMMARIZE ( Invoice_items, Invoices[Inv_No], Invoice_items[Product] ),
    CALCULATE (
    DIVIDE ( SUM ( Receipts[Amount] ), SUM ( Invoices[Amount] ) )
    * SUM ( Invoice_items[Amount] )
    )
    )

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

fbarry's avatar
fbarry
Frequent Visitor
6 years ago

Hi Greg_Deckler , 

Thanks for your reply. 

Although your suggested mesure will work at row level, the total will not tot up correctly as it's not an iterated expression. 

 

  • fbarry's avatar
    fbarry
    Frequent Visitor
    6 years ago

    Hi Greg_Deckler ,

     

    I've had a look at your Final Word post (which is a great article btw). However, the Summarize function does not appear to like my 

    [Inv % Paid] measure. It's just returning blank results when this measure is used in the expression.