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
Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
3 years ago

I tried but it didn't change at all:

Filtered measure =
SUMX (
VALUES ( 'DBA klient_tiekejai'[kli_pav] ),
CALCULATE ( [_m_ST_Bendra_Skola], FILTER ( '_Measures_ST_PS', [DATA PRADELSIMAS_ST] <= 30 ) )
)
 

 

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: