Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

hola

hola Martes Hola Aquí tengo algunos datos de muestra. C_ID C_PHONE B_POINT 16015 161622020 151.2176 60154 161622020 744.0992 60021 131619522 61.9386 60121 1316...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

@abc_777 , pruebe estas dos medidas

M1 = calcular(max(Tabla[B_POINT]), filter(allselected(Tabla), Tabla[C_ID] = max(Tabla[C_ID]))


M2 = calculate(Sum(Table[B_POINT]), keepfilter(topn(5,allselected(Table[C_ID]), [M1], desc))) + calculate(Sum(Table[B_POINT]), keepfilter(topn(5,allselected(Table[C_ID]), [M1], asc)))