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 t...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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