Forum Discussion
Count and Countrows returning 'Blank' Value
I have a table with over 200,000 phone calls; but when I use 'Count' or 'Countrows' the value returned is blank.
What could be the underlying issue?
My measure is:
Total Calls = COUNTROWS(Phone)
11 Replies
I ran into this issue as well and later found I had a page level filter which was referencing old name of the query instead of the new one. Updating that fixed the count right away.
OK, there are a number of possibilities here.
- Is the relationship with the date table active or inactive?
- Are you sure that the date column in your phone call table is actually the date datatype and not datetime? Like in the query, what is it set to? If it's datetime in the query, even if you set the datatype to date in the Power BI data model it won't work. There are other digits hidden so the dates will never match a date in your date table.
- If none of that solved it, tell me more about this indexing table.
