Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello PBI Community,
Having a frustrating issue with my PBI file. I completed the weekly file refresh and now a couple of the calculated measures in one of my report tables is no longer totaling correctly.
I have been updating this file on a weekly basis since early March 2019 without fail and now suddenly a couple of the table columns are no longer totaling correctly.
Remediation Steps I have tried:
- compared against the source file and the grand total in power bi is definitely incorrect for the two columns.
- checked visual, page, and report level filters
- recreated the measure
- reloaded, refreshed
- having massive problems refreshing in desktop and online, i have only been able to refresh successfully one time over the past 6 hours of trying. keep getting errors like EOF 0 bytes, ODEB error, etc.
The two problem columns are around calculating total current headcount and total current pay
Example of the calculated measure for total current headcount:
CF_Current Total Active Headcount =
VAR _Date1 = LASTDATE('1 Actives_Embedded'[Report Effective Date])
VAR _HeadCountDate1 =
CALCULATE (
DISTINCTCOUNT ( '1 Actives_Embedded'[Employee ID] ),FILTER(ALL('1 Actives_Embedded'[Report Effective Date]),'1 Actives_Embedded'[Report Effective Date]=_Date1))
RETURN
_HeadCountDate1
Screenshot of the table (note the line items are correct, it is just the grand total on "Most Recent Active Headcount" in the table that is not correct, as well as the calculated difference "Headcount Change" does not align with the actual line items):
Solved! Go to Solution.
The issue was due to a category name change that was causing the table to drop the data.
Hi @Anonymous
Do you have a sample file?
I cannot provide an actual sample file. I have an "Actives" file that contain millions of records and columns. The file gets appended every week. The basic info the calculation is using is Report Effective Date and Employee ID. For example:
Report Effective Date | Employee ID |
11/7/2019 | 12044 |
11/7/2019 | 12045 |
11/14/2019 | 12044 |
11/14/2019 | 12057 |
11/14/2019 | 12061 |
I believe we have identified the issue. Will report back when confirmed.
The issue was due to a category name change that was causing the table to drop the data.
Hi amy_mcmasters,
It seems that you solved this problem, right? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That's great! you may close this thread and accept this as solution for future references.
Thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |