Measure Won't Total

[Gwhiz]

How can I get the following measure to total? It is already formatted as a number but will not total.

HIPAA =

iferror(

If(search("HIPAA",min('Quotes'[Legal]))>0,1,0),

0)

[amitchandak · Accepted solution]

Try something like that

HIPAA =
iferror(
sumx('Quotes',If(search("HIPAA",'Quotes'[Legal],1,0)>0,1,0)),
0) //edited

[Gwhiz]

I tried this and it adds the total to every row but not the grand total. Each row shows 49 no matter what filter I put on @amitchandak 

[Gwhiz]

@amitchandak Disregard my comment, I was using a calculated column and not a measure. It works perfectly as a measure, fyi there was a comma missing before the last 0 to anyone looking at this solution.