Problem using max on a measure

[saritart1]

Hello everyone,

I have the following problem: 

My database is organized by classes, so I have a variable that has the number of classes. (Like shown in FIGURE 1) 

I created a 3 measures that take the value of 1 for some cases. Now, I want to add those 1´s but BY CLASS. Now, I have been able to sum it IN TOTAL, but I want to have the value of the LAST one. This is what I did: 

Alta = CALCULATE(SUMX(asistencia; asistencia[Intensidad alta]);

FILTER (

ALL ( asistencia );

asistencia[Clase] <= MAX ( asistencia[Clase] )

)

)

where: 

asistencia[Intensidad alta] is a measure

asistencia[Clase] is a column

But it doesn´t work, the result is the SUM of all the 1´s.

I am looking for something dynamic that can change if a have a class slicer.

 FIGURE 1

 The final goal is to create a donut chart that sums the kids that has small, medium or large attendance acording to the % of attendance (which is already calculated). I just want to classified it. 

In FIGURE 2 the circled measure is the one I want to chart. As it is a measure, it is dynamic and changes according to the number of class. I want the donut to change as well. 

FIGURE 2

[v-cherch-msft]

Hi @saritart1

It seems you may try to use below measure.

Alta =
SUMX (
    FILTER (
        ALLSELECTED ( asistencia ),
        asistencia[Clase] = MAX ( asistencia[Clase] )
    ),
    asistencia[Intensidad alta]
)

Regards,

Cherie