Forum Discussion
Unique date wise unique Product Count
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 |
PowerPivot is crashing on my system so i cannot frame this solution in MS Excel.
10 Replies
Hi,
Drag Inspection date to the visual and write this measure
Measure = distinctcount('PDA Data'[Product])
Hope this helps.
No its not working... It is count the Unique PDI Data [Product]... i need Unique Date Wise, unique Product Count...
Based on the data that you have shared, show the expected result clearly.
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
