Forum Discussion
Summarize error but no Summarize function
Hi Akhil,
Thanks for the follow up. We actually went another direction with the DAX in this case so it was not the solution in this case. However, I did forward your code on to the team for use in another similar situation.We appreciate your work there. Kudos given and thank you!
Hi lmolus
Thank you for reaching out to the Microsoft Community Forum.
The column '<oii>Day</oii>' specified in the 'SUMMARIZE' function was not found in the input table.
You mentioned you're:Not using SUMMARIZE explicitly, using a shared dataset, creating a line chart with PERIOD (x-axis) and a running total measure (y-axis).
Use this is a semantic model or visual layer error where Power BI's internal engine tries to generate an implicit summarization (often during visual grouping or auto-detection of granularity).
The error message references HTML-encoded text (<oii>Day</oii>),
Auto grouping or hierarchy detection is happening in the background (e.g., auto Date hierarchies). The column Day (or a hierarchy level within a hidden or deleted Date field) is referenced in the visual metadata or filters but not accessible in the current model context.
Disable Auto Date/Time Hierarchies
Power BI automatically creates hidden Date tables, and visuals may reference a missing "Day" level.
Fix: Go to File > Options and Settings > Options > Data Load
Under Time Intelligence, uncheck, Auto Date/Time for new files, And for current file under "Current File" section, uncheck the same
Then rebuild the chart using the actual [PERIOD] column instead of any field with a date type unless you intentionally want that.
Clear the Visual Filters and Rebuild the Chart
If the visual previously had a hierarchy (like Date > Month > Day), the metadata may still reference a dropped field. To fix this Delete and recreate the visual from scratch
Add only: PERIOD to the X-axis and [Impact Running Total] to the Y-axis
Since you're using a shared model, there may be:A field named Day that’s hidden or a calculated table/column that was deleted but still referenced in the visual.
Impact Running Total = VAR SelectedYear =SELECTEDVALUE ( '2FD_Fiscal Calendar'[FISCALYEAR] )
VAR CurrentPeriod = SELECTEDVALUE ( '2FD_Fiscal Calendar'[PERIOD] )
VAR MaxPeriodInYear = CALCULATE (MAX ( '2FD_Fiscal Calendar'[PERIOD] ), ALL ( '2FD_Fiscal Calendar' ),'2FD_Fiscal Calendar'[FISCALYEAR] = SelectedYear )
RETURN
IF (NOT ISBLANK ( CurrentPeriod ) && CurrentPeriod <= MaxPeriodInYear,
CALCULATE (SUMX (FILTER (ALL ( '2FD_Fiscal Calendar' ),'2FD_Fiscal Calendar'[FISCALYEAR] = SelectedYear &&'2FD_Fiscal Calendar'[PERIOD] <= CurrentPeriod),
ROUND ( ( [YTD Pct Sales] - [PYTD Pct Sales] ) * 10000, 0 ) )))
If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.
Thank you.
Hi TrentS
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,Akhil.
Hi,
We have NOT solved this one yet. The AI response was not helpful and so as Imolus alluded to above, we are trying to rewrite the DAX for another method.Hi TrentS
Apologies if the earlier explanation wasn’t helpful or felt off the mark and thank you for your patience while working through this.
Based on the issue and the direction you and Imolus are heading (rewriting the DAX), here’s a restructured version that may help reset the visual context more cleanly. This approach uses ALL() on the calendar table to remove any lingering filters such as a hidden "Day" reference that might be causing Power BI's engine to inject unexpected logic:
Impact Running Total =
VAR SelectedYear = SELECTEDVALUE('2FD_Fiscal Calendar'[FISCALYEAR])
VAR CurrentPeriod = SELECTEDVALUE('2FD_Fiscal Calendar'[PERIOD])
VAR MaxPeriodInYear = CALCULATE(MAX('2FD_Fiscal Calendar'[PERIOD]), ALL('2FD_Fiscal Calendar'), '2FD_Fiscal Calendar'[FISCALYEAR] = SelectedYear)
RETURN
IF (NOT ISBLANK(CurrentPeriod) &&CurrentPeriod <= MaxPeriodInYear,
CALCULATE(SUMX(FILTER(ALL('2FD_Fiscal Calendar'),'2FD_Fiscal Calendar'[FISCALYEAR] = SelectedYear && '2FD_Fiscal Calendar'[PERIOD] <= CurrentPeriod), ROUND(([YTD Pct Sales] - [PYTD Pct Sales]) * 10000, 0))))If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.
Regards,
Akhil.