Forum Discussion

New_Folder's avatar
New_Folder
Icon for Helper I rankHelper I
7 months ago
Solved

Count is incorrect. What could have been causing this?

  What should I be looking for?   MH7 is a measure that counts the last 7 days, it should be counting 7, but its just showing 4.   MH7 = CALCULATE( DISTINCTCOUNT('Utility Allowance Track...
Need Help
  • Zanqueta's avatar
    Zanqueta
    7 months ago

    Hi New_Folder , if possible, share a sample data without sensible content in order to give us an way to replicate your issue. 
    In time, maybe you should check

    1. Whether you intend to count rows or distinct dates.
    2. The actual content and granularity of the Created field.
    3. Hidden filters affecting the visual.
    4. Inconsistencies in Client Name.
    5. Whether the record has Created values that are blank, null or truncated.

       

     

Zanqueta's avatar
Zanqueta
Icon for Super User rankSuper User
7 months ago

Hi New_Folder , if possible, share a sample data without sensible content in order to give us an way to replicate your issue. 
In time, maybe you should check

  1. Whether you intend to count rows or distinct dates.
  2. The actual content and granularity of the Created field.
  3. Hidden filters affecting the visual.
  4. Inconsistencies in Client Name.
  5. Whether the record has Created values that are blank, null or truncated.