Forum Discussion
Solved
Help with Dax
Trying to figure out a measure to get the Case number and the Critical errors. So I need Case Number 1 with 7 critical errors not 21 critical errors. The Total Critical Errors column is the total but it is showing for each row. Thank you
| Case Number | Start date | Total Critical Errors | Total Non Critical errors |
| 1 | 5/19/2023 | 7 | 11 |
| 1 | 5/19/2023 | 7 | 11 |
| 1 | 5/19/2023 | 7 | 11 |
| 2 | 5/18/2023 | 5 | 3 |
| 2 | 5/18/2023 | 5 | 3 |
| 3 | 5/19/2023 | 6 | 5 |
| 3 | 5/19/2023 | 6 | 5 |
