Not able to do Sum multiple measures

[avi081265]

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(Merge1[Id]),Merge1[Items.Level-2]="Drawings")=0,1,0)

3.  MissingRisk = If(calculate(count(Merge1[Id]),Merge1[Items.Level-2]="Risk")=0,1,0)

I am able to display above 3 measures value in table for each items as mentioned below

Now I want to display sum of the count seprately, not in this table, so I create formula as mentioned below, but it always display One (1)

TotalCount = [MissingSchemedesign]+[MissingDrawings]+[MissingRisk]

It should show Nine (9) not One (1)

Please let me know what wrong I am doing.

Regards

Avian

[Ahmedx]

[avi081265]

Thanks It is working

However column headers are displaying empty.

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

[avi081265]

Thanks Ahmedx, it works.

One more question,  I want to display data in following format using measure field. I tried in Table and Matrix, but no luck. Any other format I am missing

Missing	Count
Missingschemedesign	1
Missing Drawing	0
Missing Risk	1
Total	2

[Ahmedx · Accepted solution]

try writing like this

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