Forum Discussion

avi081265's avatar
avi081265
Icon for Helper III rankHelper III
3 years ago
Solved

Not able to do Sum multiple measures

Hello All, I created 3 measures as mentioned below 1.  MissingSchemedesign = If(calculate(count(Merge1[Id]),Merge1[Items.Level-2]="Scheme design")=0,1,0) 2.  MissingDrawings = If(calculate (count(...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    try writing like this

    TotalCount =
      SUMX(
           VALUES('table'[Machine No]),
         [MissingSchemedesign]+[MissingDrawings]+[MissingRisk])

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

try writing like this

TotalCount =
      SUMX(
           VALUES('table'[Machine No]),
         [MissingSchemedesign]+[MissingDrawings]+[MissingRisk])