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...
Hi,
Try this measure
=
Count = if(HASONEVALUE(Data[Month]),DISTINCTCOUNT(Data[Model]),DISTINCTCOUNT(Data[SerialNumber]))
Hope this helps.
If you look at the monthly breakdown for 'Product A' it doesnt add up, even though the Total '7' is correct.
My result is correct. 33729 appears 3 times but in different months. Check your data carefully. If you still think i am incorrect, please share the exact expected result with an explanation.
'Product A' appears 9 times in the Dataset and it has 7 different SerialNumbers. DistinctCount Total of 7 is the correct number for Product A, but the monthly breakdown only shows 5.
Below is how the result needs to Display.