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
it works fine, but I can no longer filter on impact types.
I'd like to have something like
but neither of those works.
Any idea of what I'm doing wrong ?