Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Here is the table and Desired Result for DISTINCT Count. 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Based on that data that you have shared, =distinctcount(data[serial number]) should return the correct result for every month.  If not, then share the link from where i can download your PBI file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Hi,

      Try this measure

      =

      Count = if(HASONEVALUE(Data[Month]),DISTINCTCOUNT(Data[Model]),DISTINCTCOUNT(Data[SerialNumber]))
      Hope this helps.
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        If you look at the monthly breakdown for 'Product A' it doesnt add up, even though the Total '7' is correct.