Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
3 years ago

Filter measure in Power BI

Hi,   I would like to filter measure according to another measure condition. For example, calculate(a, filter(b<30). But problem is that new column becomes same as old. I don't get why it happens....
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

Try

Filtered measure =
SUMX (
    FILTER (
        VALUES ( 'DBA klient_tiekejai'[kli_pav] ),
        [DATA PRADELSIMAS_ST] <= 30
    ),
    CALCULATE ( [_m_ST_Bendra_Skola] )
)
Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
3 years ago

I have inserted that measure but my visual can't load,  memory exceeded. Getting this: