Forum Discussion

Gwhiz's avatar
Gwhiz
Icon for Helper I rankHelper I
6 years ago
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)
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try something like that


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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try something like that


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

Gwhiz's avatar
Gwhiz
Icon for Helper I rankHelper I
6 years ago

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's avatar
    Gwhiz
    Icon for Helper I rankHelper I
    6 years ago

    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.