Forum Discussion
Retention Condition measures
Hi, I have been posting this same problem but could not solve it yet. I attached my demo power bi file in the googld doc link. So, I need to get customer who meets at least one of the 3 conditions ...
Anonymous - Chapter 6, recipes 2 and 3 deal with customer KPI's around new, returning, retained, lost customers.
Hey, Thank you so much for reply. But I try to apply on my pbi but it took so long time to visualize...
Case1 =
var _2year =
DISTINCT(
SELECTCOLUMNS(
FILTER(
ALL('UCC DATA'),
[Date] < MAX('UCC DATA'[Date])-730
),
"Last 2 Year",'UCC DATA'[Customer]
)
)
Var NotDoosan =
DISTINCT(
SELECTCOLUMNS(
FILTER(
'UCC DATA','UCC DATA'[Manufacturer]<>"DOOSAN"
),
"NotDoosan", 'UCC DATA'[Customer]
)
)
Var DoosanCustomer = EXCEPT(_2year,NotDoosan)
Var _Count = COUNTROWS(DoosanCustomer)
Return
IF(ISBLANK(_Count),0,1)
This is my formula but it does show visualize and keep showing the loading sign on the top left corner of the visual.
How can I solvel this problem?
Anonymous - Difficult to say. I have some blog articles around DAX performance tuning.
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-2/ba-p/976813
Also, marcorusso has some patterns on daxpatterns.com for this sort of stuff as well. Should have mentioned those initially.