Forum Discussion
Sum Group by type
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.
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:
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.