Forum Discussion

avi081265's avatar
avi081265
Helper 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
Super User
3 years ago

avi081265's avatar
avi081265
Helper III
3 years ago

Thanks It is working

 

However column headers are displaying empty.

 

I also dont want to display those measures where is count is zero.