Forum Discussion
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(...
try writing like this
TotalCount = SUMX( VALUES('table'[Machine No]), [MissingSchemedesign]+[MissingDrawings]+[MissingRisk])
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 |