Convert formula of new column into new measure.

[Anonymous]

Hello,

I tried to use the formula on the new column into new measure because my goal is to reduce the load of the data but it's not working.

= IF (

CONTAINSSTRING ( vw_aps1[RT1], "KBA" ) ||

CONTAINSSTRING ( vw_aps1[RT2], "Selective Recall" ),

1,

0

)

How do i make it work in new measure?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , Try one of the two

= IF (

CONTAINSSTRING ( max(vw_aps1[RT1]), "KBA" ) ||

CONTAINSSTRING ( max(vw_aps1[RT2]), "Selective Recall" ),

1,

0

)

or

= Sumx(vw_aps1, IF (
CONTAINSSTRING ( vw_aps1[RT1], "KBA" ) ||
CONTAINSSTRING ( vw_aps1[RT2], "Selective Recall" ),
1,
0
))