Sum Group by type

[JYPARK]

Hi everyone,

Seeking for assistance.   I am trying to sum up the number of failure types.  However, I am not sure how I can do this.  

[v-xuding-msft]

Hi @JYPARK ,

You could try the formula if you want to count the number of failure types based on item id.

Measure  = CALCULATE(DISTINCTCOUNT('Table '[failure types]),ALLEXCEPT('Table ','Table '[item id]))

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cmcmahan]

You're just trying to count how many distinct item_failure_types you have? That's easy enough:

FailureTypes = DISTINCTCOUNT('Table 1'[item_failure_type])

[JYPARK]

I tried this method but when I select "New Column" and enter this 

FailureTypes = DISTINCTCOUNT('item_registration'[item_failure_type])

I get this error message:

---

---

---

---

[sgsukumaran]

@JYPARK   From your screenshots it appears that you are using direct query model. If so you cannot add columns at this time. You can only create measures. You are tryin to accomplish row context and the best way to do this is to add your logic to your model.

[Cmcmahan]

Don't try and create this as a new column.  Create it as a new measure.