Forum Discussion
jalaomar
Helper IV
Helper IVIssue with data wrong on row level when no filter applied but correct when applying filter
Dear all, I am stuck with an issue with my data and not sure how to proceed. I have a table with all projects and in this table we capture monthly snapshots related to sales , budget. I have cre...
Hi jalaomar It might be because SUMX aggregates across rows without proper filter context. Modify your measure to explicitly filter by the current date for example like CALCULATE([Sales Price], TABLE[Date] = MAX(TABLE[Date])). Ensure the Date field is included in the visualization or model filters.
Akash_Varuna
Super User
Super UserHi jalaomar It might be because SUMX aggregates across rows without proper filter context. Modify your measure to explicitly filter by the current date for example like CALCULATE([Sales Price], TABLE[Date] = MAX(TABLE[Date])). Ensure the Date field is included in the visualization or model filters.