Forum Discussion
DISTINCTCOUNT
This Data is about the Monthly Serviced units. One unit can get serviced multiple times in a month or year. However, when I count the total unit serviced I do not want the same unit being accounte...
Thank you Ashish for taking a look. Here is the File Link.
Ashish_Mathur
Super User
Super UserHi,
Try this measure
=
Count = if(HASONEVALUE(Data[Month]),DISTINCTCOUNT(Data[Model]),DISTINCTCOUNT(Data[SerialNumber]))
Hope this helps.