Forum Discussion

CarlZ22's avatar
CarlZ22
Regular Visitor
4 years ago
Solved

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...
  • v-luwang-msft's avatar
    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 Regards

    Lucien