Forum Discussion
Solved
Measure Won't Total
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)
Try something like that
HIPAA =
iferror(
sumx('Quotes',If(search("HIPAA",'Quotes'[Legal],1,0)>0,1,0)),
0) //edited
3 Replies
Try something like that
HIPAA =
iferror(
sumx('Quotes',If(search("HIPAA",'Quotes'[Legal],1,0)>0,1,0)),
0) //editedI 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
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.
