Unique date wise unique Product Count

[jackypatel]

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

Refer below table for data

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

[jackypatel]

Sir, Thanx for the Help. In addition to that need counting of accepted Lot.

Example-

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

[Ashish_Mathur]

Hi,

Drag Inspection date to the visual and write this measure

Measure = distinctcount('PDA Data'[Product])

Hope this helps.

[jackypatel]

No its not working... It is count the Unique PDI Data [Product]... i need Unique Date Wise, unique Product Count...

[Ashish_Mathur]

Based on the data that you have shared, show the expected result clearly.

[jackypatel]

if calculate with Date than out put is OK, But when convert into this goes wrong.

I need output as per below

Month	Product	Count
March-23	HM-12.5A-LM-ACC-NS	1
	12.5C-FDB-ACC	1
	LTT8-20	1
	CLR400000-A2	1
	LD200686-E2	1
	LDRR24-CDL	1
	LL725003-D1	1
	LDLRC-20PRO-CDL	1
	LT8-20-865-2	1
	Total Count	9

[Ashish_Mathur]

Hi,

PBI file attached.

[jackypatel]

Thanx for the file... but i am not using Power BI. so i cant open it. Plz send me .xlsx format file or .pdf format file.

Plz

[Ashish_Mathur]

This is a PBI forum.  Before you post your question, shouldn't you ensure that you already have the software?

[jackypatel]

Sir,

I am using Power Pivot in Excel. Power BI Software is not available.

Kindly plz share the .xlsx file

[Ashish_Mathur · Accepted solution]

PowerPivot is crashing on my system so i cannot frame this solution in MS Excel.