Count IF statement Annualization

[Anonymous]

I have a measure that creates a cumulative running total for revenue. 

Cumulative Total= 

CALCULATE (

    SUM ( 'Sales Table'[Revenue] ),

    FILTER (

        ALL ( 'DIM_DATE' ),

        'DIM_DATE'[DATE_ACTUAL] <= MAX( ( 'DIM_DATE'[DATE_ACTUAL] )

    )

))

I have another measure that uses an IF statement to see if a customer is new or not. 

If Measure =

VAR CumulTot= [Cumulative Total MEASURE]

VAR preCumulTot= [CumlTotalPreviousMonth]

VAR Result= IF(CumulTot<>0 && preCumulTot=BLANK(), 1,0)

RETURN

Result

I have a measure that correctly takes the sum if viewed in "Month Year" format, but if I view in Qtr or Yr format, the counts are off.

I assume the counts are off based on the IF statement , but I am unsure how to go abt it to get accurate counts in each Date Hiearchy view?

The calc to sum the If Measure is 

If Measure Sum= SUMX(CALCULATETABLE(VALUES(Customer Table[Customer Name]),ALL(DIM_DATE[Month Year],DIM_DATE[YEAR_MONTH_NUM]),DIM_DATE[Year Month order]), [If Measure])

[Anonymous]

For some reason that works for the cumulative total but not the reverse. 

Reverse= CALCULATE (

    SUM ( 'Sales'[Revenue] ),

    FILTER (

        ALL ( 'Date'[DATE] ),

        'Date'[DATE] >= MIN( ( 'Date'[DATE] )

    )

))

I would like to use the same formula for the reverse measure, but this one does not count my totals correctly. I would like to do the same month over month calculation . IF (rev)=blank && (previousmonth rev)<>0, 1,0

Any idea?

[amitchandak · Accepted solution]

@Anonymous ,

Try  changes in the measure

If Measure =
VAR CumulTot= [Cumulative Total MEASURE]
VAR preCumulTot= [CumlTotalPreviousMonth]
VAR Result= IF(not(Isblank(CumulTot))  && isblank(preCumulTot), 1,0)

RETURN
Result

Seem like the same approach as

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458