Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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])
I tried this method but when I select "New Column" and enter this
@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.
Don't try and create this as a new column. Create it as a new measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |