Calculating % Reject from Total Inspections

Diane_Gribi — Tue, 25 Apr 2023 16:07:28 GMT

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

Re: Calculating % Reject from Total Inspections

Greg_Deckler — Tue, 25 Apr 2023 17:43:23 GMT

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

Re: Calculating % Reject from Total Inspections

Diane_Gribi — Thu, 27 Apr 2023 09:59:26 GMT

Thanks. 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

Re: Calculating % Reject from Total Inspections

Diane_Gribi — Mon, 01 May 2023 11:59:29 GMT

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

Re: Calculating % Reject from Total Inspections

Diane_Gribi — Mon, 01 May 2023 12:00:04 GMT

Managed to fix this so no need for a resolution. Thanks guys

topic Re: Calculating % Reject from Total Inspections in DAX Commands and Tips

Calculating % Reject from Total Inspections

Re: Calculating % Reject from Total Inspections

Re: Calculating % Reject from Total Inspections

Re: Calculating % Reject from Total Inspections

Re: Calculating % Reject from Total Inspections