Forum Discussion

saritart1's avatar
saritart1
Frequent Visitor
7 years ago

Problem using max on a measure

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

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee

    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