Forum Discussion

New_Folder's avatar
New_Folder
Helper 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.

       

     

Alex_Sawdo's avatar
Alex_Sawdo
Resolver II
7 months ago

When using DISTINCTCOUNT, it literally counts the "distinct" values from the column you're counting, and not the "total" number of values in the column. Try using COUNT() instead of DISTINCTCOUNT() instead. 

Also, if possible can you share a subset of data from the 'Utility Allowance Tracker - HDR'[Created] column to assist in answering your question?