Forum Discussion

ani_informa's avatar
ani_informa
Helper III
3 years ago

Calculate First Acquisition

Hi  I have a requirement wherein I want to write a DAX that can calculate the New Acquisition of customers. For example, from the sample data below, steve has enrolled first on Feb 14, 2022 and thou...
Need Help
ani_informa's avatar
ani_informa
Helper III
3 years ago

This is still not working for me. Any other solution would be highly appreciated.

My requirement is to count distinct emails considering Minimum of first_enrolled date for the Market or Brand user select from the slicer. so from the sample data, If user select "Pharma" Market from the slicer then [email protected] should be getting counted only once for the min of First_enrolled i.e. 2/14/2022 and [email protected] should be counted for 1/15/2022 (min date) so line chart should count steve under Feb 22 only and adam in Jan 22 only. Likewise if user select Brand then email for the min of first_enrolled should get counted. 

 

 

ani_informa's avatar
ani_informa
Helper III
3 years ago

Thanks for all the responses !!

 

Able to get through this. I have created a measure like this. posting this just in case if anyone else end up receiving such requirement.

 

First_Enrolled_date =
CALCULATE (      
    MIN ( Fact_table[first_enrolled] ),
    REMOVEFILTERS ( date_dimension )  
)

 

Acqusition =
var _first_engaged =
ADDCOLUMNS
(
     VALUES(Fact_table[email])
    ,"MIN", CALCULATE(MIN(Fact_table[First_Enrolled]))
)
Return
 COUNTROWS(FILTER(_first_engaged,[MIN]=[First_Enrolled_date]))