Filter measure in Power BI

[Analitika]

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.

For example,

Measure equals to Bendra skola even Measure contains blank values, so how to fix my measure to calculate correctly.

[Aburar_123]

Hi @Analitika ,

Can you just change the measure like below,

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

Please Accept it as a solution if it solves your problem. Thanks.

[johnt75]

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]

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]

Try

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

[Analitika]

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