Forum Discussion
Helper ICount is incorrect. What could have been causing this?
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- Whether you intend to count rows or distinct dates.
- The actual content and granularity of the Created field.
- Hidden filters affecting the visual.
- Inconsistencies in Client Name.
- Whether the record has Created values that are blank, null or truncated.
Community SupportHi New_Folder ,
Thank you for reaching out to the Microsoft Community Forum.
You want number of requests, but you are counting distinct Created timestamps/dates. If multiple requests were created on the same day, they collapse into one count.
Please try below measures.
1. If you want requests in last 7 days, try below measure.
MH7 =
CALCULATE(
COUNTROWS('Utility Allowance Tracker - HDR'),
'Utility Allowance Tracker - HDR'[Created] >= TODAY() - 7,
'Utility Allowance Tracker - HDR'[Client Name] = "Mercy Housing"
)
2. If you want a rolling 7-day window including time, try below measure.
MH7 =
CALCULATE(
COUNTROWS('Utility Allowance Tracker - HDR'),
'Utility Allowance Tracker - HDR'[Created] >= NOW() - 7,
'Utility Allowance Tracker - HDR'[Client Name] = "Mercy Housing"
)
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Community SupportHi New_Folder ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
- v-dineshya
Hi @New_Folder ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh