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

'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.

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You may download my PBI file from here.

Hope this helps.