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

BillWalker's avatar
BillWalker
Regular Visitor
4 years ago

Thank you Janey! This did resolve the initial issue, I greatly appreciate your help!

 

In this report, I am using "Sync Sliders" to have a first page that is all filters and subsequent pages are the actual reports. It now looks like these new measures are not respecting the filters from the first page of the report (the filters page). 

 

Can you elaborate on the measure you wrote above? SUMMARIZE creates a new table right? I assume that's impacting the new measure's ability to respect the global 'sync sliders'.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    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