Forum Discussion
Calculating % Reject from Total Inspections
hi - Looking for some Dax command help. I am looking to create a graph from data similar to below were for each month I calculate the total number of inspections (which I have managed to do), total number of rejects (which I have gotten), but I am unable to get the %rejects per month (when I try all I am able to get is the %rejection for the total reject (YTD))
Can anyone advise what I am doing wrong or suggest a formula that does the above
Thanks
| Number | Type | Event Date | GRI Result | ||
| 1 | Goods Receiving Inspection Report | 09/01/2023 00:00 | Reject | ||
| 2 | Goods Receiving Inspection Report | 10/01/2023 00:00 | Accept | ||
| 3 | Goods Receiving Inspection Report | 10/01/2023 00:00 | Accept | ||
| 4 | Goods Receiving Inspection Report | 10/01/2023 00:00 | Reject | ||
| 5 | Goods Receiving Inspection Report | 10/01/2023 00:00 | Accept | ||
| 6 | Goods Receiving Inspection Report | 10/01/2023 00:00 | Accept | ||
| 7 | Goods Receiving Inspection Report | 10/01/2023 00:00 | Accept | ||
| 8 | Goods Receiving Inspection Report | 06/02/2023 00:00 | Reject | ||
| 9 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 10 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 11 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 12 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 13 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 14 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 15 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 16 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 17 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 18 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 19 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 20 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 21 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Reject | ||
| 22 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 23 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 24 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 25 | Goods Receiving Inspection Report | 08/02/2023 00:00 | Accept | ||
| 26 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 27 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 28 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 29 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 30 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 31 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 32 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 33 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 34 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Reject | ||
| 35 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 36 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Reject | ||
| 37 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 38 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 39 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Reject | ||
| 40 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 41 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 42 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 43 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 44 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 45 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 46 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 47 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 48 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 49 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept | ||
| 50 | Goods Receiving Inspection Report | 01/03/2023 00:00 | Accept |
Diane_Gribi Maybe something like this. See PBIX attached below signature.
Measure = VAR __Rejects = COUNTROWS(FILTER('Table', [GRI Result] = "Reject")) VAR __Total = COUNTROWS('Table') VAR __Result = DIVIDE(__Rejects, __Total) RETURN __Result
4 Replies
Diane_Gribi Maybe something like this. See PBIX attached below signature.
Measure = VAR __Rejects = COUNTROWS(FILTER('Table', [GRI Result] = "Reject")) VAR __Total = COUNTROWS('Table') VAR __Result = DIVIDE(__Rejects, __Total) RETURN __ResultThanks. I have managed to get my graph, but it is not organising it by month (Jan, Feb, Mar) it looks to have sorted it alphabetically. Do you know how to reorder it
Managed to fix this so no need for a resolution. Thanks guys
Thanks sorry, meant to reply. had a little trouble with something else on the file that was showing up strange values, but got it all sorted now. Thanks
