Forum Discussion
CarlZ22
4 years agoRegular Visitor
count distinct and data integrity
hello, I have a data set with service records and they are ranked by low med high at each visit. tech will go visit the same device (fridge) multiple times a year under the same case number and devi...
- 4 years ago
Hi CarlZ22 ,
Why your data:uniq count of open cases for ax=1?And from the base data, I think it may be 2.
You could download my pbix file ,and refer it.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
v-luwang-msft
Community Support
4 years agoHi CarlZ22 ,
Why your data:uniq count of open cases for ax=1?And from the base data, I think it may be 2.
You could download my pbix file ,and refer it.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien