Forum Discussion
jackypatel
Helper I
Helper IUnique 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 ...
PowerPivot is crashing on my system so i cannot frame this solution in MS Excel.
Ashish_Mathur
Super User
Super UserHi,
Drag Inspection date to the visual and write this measure
Measure = distinctcount('PDA Data'[Product])
Hope this helps.
jackypatelHelper I
Helper INo 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.