Forum Discussion

Helper V

3 years ago

Solved

Variable Help

Hi there, I have the following measure which I need to adapt to include a Measure in place of the Amount field in the Dyn_OpportunityProduct table.. Product Target Filtered Sales = sumx ( ...

PaulOlding

3 years ago

Hi Tob_P

You could replace the SUM(...) with a measure. That would give you

Product Target Filtered Sales =
sumx (
    'tblRep_List',
    VAR BonusStartDate ='tblRep_List'[Product Bonus Start Date]
    RETURN
    CALCULATE(
        [Your Measure],
        KEEPFILTERS(
            'CRM: Opportunity'[Date Spec Secured] >= BonusStartDate)))+0

I'd suspect performance could be an issue if you have a sizable amount of data.

amitchandak

Super User

3 years ago

Tob_P , if you do calculation inside expression of sumx, you need calculate. else you can have like

measure = VAR BonusStartDate ='tblRep_List'[Product Bonus Start Date]
RETURN
CALCULATE(
SUM('Dyn_OpportunityProduct'[Amount]),
KEEPFILTERS(
'CRM: Opportunity'[Date Spec Secured] >= BonusStartDate))

Product Target Filtered Sales =
sumx (
'tblRep_List', [measure]
)+0

Product Target Filtered Sales =
sumx (
'tblRep_List', [Any measure]
)+0