Forum Discussion

BillWalker's avatar
BillWalker
Regular Visitor
4 years ago
Solved

Question on a Measure that's Failing

Greetings community!   I'm struggling with a Measure I am using in a report that looks at a table of sales opportunities. The idea is to only sum up the total of  'Billing Amount' if an opportunity...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, BillWalker 

     

    Try to change all to allselected, so the result will change with the context.

    measure =
SUMX (
    SUMMARIZE (
        ALLselected ( 'Table' ),
        [Opportunity Name],
        "a", MAX ( 'Table'[Billing Amount] )
    ),
    [a]
)

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, BillWalker 

 

"A table of multiple values was supplied where a single value was expected" message." This error message should be from dax code. But you only provided one measure, and there was no error according to the sample you provided,

If it's wrong, it must be in conflict with your context. To avoid this problem, you can use summarize() to create a context yourself.

Like this:

measure =
SUMX (
    SUMMARIZE (
        ALL ( 'Table' ),
        [Opportunity Name],
        "a", MAX ( 'Table'[Billing Amount] )
    ),
    [a]
)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey