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

When the calculation is performed at the grand total level then the filter condition is met. You need to iterate over whichever column provides a unique identifier for the row in your table, e.g. if the rows each show a different date then you could use

Filtered measure =
SUMX (
    VALUES ( 'Date'[Date] ),
    CALCULATE ( [A], FILTER ( 'Table', [B] < 30 ) )
)

 

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: