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(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
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    try writing like this

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

     

4 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    try writing like this

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

     

  • avi081265's avatar
    avi081265
    Helper III
    3 years ago

    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

    MissingCount
    Missingschemedesign1
    Missing Drawing0
    Missing Risk1
    Total2

     

     

    • 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.