Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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)
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.
Are there relationships with other tables involved here?
Proud to be a Super User!
OK, there are a number of possibilities here.
Proud to be a Super User!
I have stopped creating date tables, and now create additinal columns within the table separating the month, day and year from the date column. After, I create attach an excel spreadsheet with distinct date values. This seems to be easier with lots of tables with multiple dates and years.
The problem was in the indexing table, I made the relationship inactive, and it is now working. I will have to see what the issue is with the relationship.
I just lost $20!? 🙂
@Anonymouscan I claim that you owe me $20 since inactive relationship was #1 on my list?
Proud to be a Super User!
Yeah but I did say inactive relationship in #1. Shhh, back me up on this. I'll split the $20 with you!
Proud to be a Super User!
LOL 🙂
I got $20 on "the date relationship has times in the fact table". You can't JUST change the "Data type" and/or "Format" on the Modeling ribbon... which, I dunno... I think i wish it works for Data Type at least?
You need to change the underlying data to NOT HAVE times (hopefully just using "Edit Queries")
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |