Forum Discussion

uscmea's avatar
uscmea
Frequent Visitor
5 years ago
Solved

Cumulative Sum

Hi, I have three main measures in my data model:   sales = DISTINCTCOUNT(Sales[Product ID]) leads = DISTINCTCOUNT(Leads[Lead ID]) conv = IF([vacation_days]<7,[sales]/[leads],0)   The meas...
  • DataInsights's avatar
    DataInsights
    5 years ago

    uscmea,

     

    Try this measure:

     

    cum_conv = 
VAR vCurrentMonth =
    MAX ( 'Calendar'[Month Number] )
VAR vTable =
    ADDCOLUMNS ( ALLSELECTED ( 'Calendar'[Month Number] ), "@conv", [conv] )
VAR vResult =
    SUMX ( vTable, IF ( 'Calendar'[Month Number] <= vCurrentMonth, [@conv] ) )
RETURN
    vResult

     

     

DataInsights's avatar
DataInsights
Super User
5 years ago

uscmea,

 

Try this measure:

 

cum_conv = 
VAR vCurrentMonth =
    MAX ( 'Calendar'[Month Number] )
VAR vTable =
    ADDCOLUMNS ( ALLSELECTED ( 'Calendar'[Month Number] ), "@conv", [conv] )
VAR vResult =
    SUMX ( vTable, IF ( 'Calendar'[Month Number] <= vCurrentMonth, [@conv] ) )
RETURN
    vResult

 

 

uscmea's avatar
uscmea
Frequent Visitor
5 years ago

Thank you very much for your help, DataInsights !!