Count IF statement Annualization

Question

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])

amitchandak · Accepted Answer

Anonymous , 
Try&nbsp; changes in the measure
If Measure =VAR CumulTot= [Cumulative Total MEASURE]VAR preCumulTot= [CumlTotalPreviousMonth]VAR Result= IF(not(Isblank(CumulTot))&nbsp; &amp;&amp; isblank(preCumulTot), 1,0)
RETURNResult
&nbsp;
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/1361529Customer 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

Forum Discussion

Count IF statement Annualization

2 Replies

Related content

Counting nulls

Prorated annual expense

OR Statement ?

SQL Statement opcion error

Count Of Drivers