Forum Discussion

Tob_P's avatar
Tob_P
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's avatar
    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.

PaulOlding's avatar
PaulOlding
Solution Sage
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.