Forum Discussion

equlibrum96's avatar
equlibrum96
New Member
2 years ago
Solved

Filtering by iterator in calculated column

Hello everyone Hello, I am a young PowerBi adept and I need help in calculating a new calculated column    My data looks like this: I have a case table, a calls table, and the so-called bridge tab...
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, equlibrum96 

     

    You can try the following methods.

    Measure = 
CALCULATE ( MIN ( 'calls table'[call_date] ),
    FILTER ( ALL ( 'calls table' ),
        [status] = "picked up"
            && [call_date] > MAX ( 'case table'[first_contact_date] )
            && RELATED ( 'case_calls table'[call_id] ) = MAX ( 'calls table'[call_id] )
    )
)

    Column = CALCULATE ( MIN ( 'calls table'[call_date] ),
    FILTER ( 'calls table' ,
        [status] = "picked up"
            && [call_date] > EARLIER( 'case table'[first_contact_date] )
            && RELATED ( 'case_calls table'[case_id] ) = EARLIER('case table'[case_id])
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, equlibrum96 

 

You can try the following methods.

Measure = 
CALCULATE ( MIN ( 'calls table'[call_date] ),
    FILTER ( ALL ( 'calls table' ),
        [status] = "picked up"
            && [call_date] > MAX ( 'case table'[first_contact_date] )
            && RELATED ( 'case_calls table'[call_id] ) = MAX ( 'calls table'[call_id] )
    )
)

Column = CALCULATE ( MIN ( 'calls table'[call_date] ),
    FILTER ( 'calls table' ,
        [status] = "picked up"
            && [call_date] > EARLIER( 'case table'[first_contact_date] )
            && RELATED ( 'case_calls table'[case_id] ) = EARLIER('case table'[case_id])
    )
)

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.