DAX Trouble with count and Max Date

Hi Anonymous,

You can try to use below sample if it suitable for your requirement.

Steps:

1. Filter the not contains records.

Filtered Table = FILTER(Sheet1,CONTAINS(Sheet2,[usu_id_i],[usu_id_i]))

2. Add a calculated column to analysis the count of date range based on 'category id' group:

Count = 
var compare_range = 1
return
COUNTX(FILTER('Filtered Table',[ge_categoria_id]=EARLIER([ge_categoria_id])&&[fecha_inicio]>=EARLIER([fecha_inicio])-compare_range&&[fecha_inicio]<=EARLIER([fecha_inicio])+compare_range),[fecha_inicio])

 3. Summary these records.

Result = SUMMARIZE('Filtered Table',[ge_categoria_id],"Clients",MAX('Filtered Table'[Count]))

Notice: you can modify the variable 'compare_range' to switch the compare range. Step 1 is an option, you can skip it if you need.

Regards,

Xiaoxin Sheng

Anonymous

Hi, what happen with users 52,23,8078 do you want to count them too

Because including it the result will be 6 & 3.

Victor

Lima - Peru