If() text condition help

[Saryk]

Hello,

I want to sum([Alerts]) if (impact='1*'), or if (impact='2*'), up until impact='4*' as a measure in a bar graph.

If I write

=Sum({<Impact={"1*"}>}[Alerts])

it works fine, but I can no longer filter on impact types.

I'd like to have something like 

=if(impact='1*', Sum(Alert))

or 

=if(WildMatch(Impact, '1*'),Sum([Alert]))

but neither of those works.

Any idea of what I'm doing wrong ?

[Sergio3 · Accepted solution]

Hi,

If u want filter on impact types,

U need "*":

=Sum({<Impact*={"1*"}>}[Alerts])

[Saryk]

Well, it seems to work fine if I flip it around : 

=Sum(if(Left(Impact, 1)='1',Alerts,0))

Thanks anyway, hope this helps someone in the future ! 

[Saryk]

Or that, I just checked and it works.

Thank you, it looks cleaner than my solution !