Unique date wise unique Product Count & Accepted Rejected Count

[jackypatel]

My Database name is "PDI DATA"&  i required Unique date wise unique names count & Accepted, rejected Count too. E.g. 27-03-2021 has "HM-12.5A-LM-ACC-NS" count is 1 and Accepted Count 1 & 27-03-2021 has "12.5C-FDB-ACC" also count is 1and Accepted Count 1. And at the end i need Grand total of counts

Inspection Date	Product	Result
27-03-2021	HM-12.5A-LM-ACC-NS	Accepted
27-03-2021	HM-12.5B-LM-ACC-NS	Accepted
27-03-2021	12.5C-FDB-ACC	Accepted
27-03-2021	LTT8-20	Accepted
25-03-2021	CLR400000-A2	Rejected
26-03-2021	LD200686-E2	Accepted
26-03-2021	LD200686-E2	Accepted
26-03-2021	LD200686-E2	Accepted
26-03-2021	LD200686-E2	Accepted
25-03-2021	LDRR24-CDL	Rejected
25-03-2021	LDRR24-CDL	Rejected
25-03-2021	LL725003-D1	Accepted
25-03-2021	LL725003-D1	Accepted
25-03-2021	LL725003-D1	Accepted
25-03-2021	LL725003-D1	Accepted
25-03-2021	LL725003-D1	Accepted
25-03-2021	LL725003-D1	Accepted
25-03-2021	LL725003-D1	Accepted
25-03-2021	LDLRC-20PRO-CDL	Accepted
25-03-2021	LT8-20-865-2	Accepted
25-03-2021	LT8-20-865-2	Accepted
25-03-2021	LT8-20-865-2	Accepted
25-03-2021	LT8-20-865-2	Accepted
25-03-2021	LT8-20-865-2	Accepted
25-03-2021	LT8-20-865-2	Accepted
25-03-2021	LT8-20-865-2	Accepted

[ERD · Accepted solution]

Hi @jackypatel , you can try these measures:

names = DISTINCTCOUNT('PDI DATA'[Product])

accepted = 
VAR _t =
    SUMMARIZE (
        'PDI DATA',
        'PDI DATA'[Inspection Date],
        'PDI DATA'[Product],
        'PDI DATA'[Result]
    )
VAR _accepted = FILTER ( _t, [Result] = "Accepted" )
RETURN
    COUNTX ( _accepted, [Result] )

[jackypatel]

thanx for the help

[Ahmedx]

Is this what you are looking for?

Sample PBIX file attached