Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
If u want filter on impact types,
U need "*":
=Sum({<Impact*={"1*"}>}[Alerts])
Hi,
If u want filter on impact types,
U need "*":
=Sum({<Impact*={"1*"}>}[Alerts])
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 !
Or that, I just checked and it works.
Thank you, it looks cleaner than my solution !