Calculating % Reject from Total Inspections

[Diane_Gribi]

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

[Greg_Deckler · Accepted solution]

@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

[Diane_Gribi]

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

[Diane_Gribi]

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

[Diane_Gribi]

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