Forum Discussion
Impactful Individualtotals dont match
i removed the one FYTD table from the model. I converted floats to decimal (18,6). I moved some calc responsibility away from DAX into the sql views. I left some applied sort , rename and maybe dupe steps deleted. I removed one critical flag that was probably working but now cant even get to pbi thanks to a sql predicate blocking it.
All numbers match now not only to our warehouse $'s, but between the desktop and service as well. Hard to explain (rounding errors) to the user when the main focus was on making the report smarter on the 1st of the month. The report always tried to report thru "Yesterday". With previous authors so fixed on the Today() function, that created some challenges.
Community SupportHi db042190
Thank you for reaching out to the Microsoft Fabric Community Forum and thank you rohit1991 and Greg_Deckler for sharing the insights.
The difference in FYTD totals between Power BI Service and Desktop is likely caused by a persistent filter or an automatic bookmark in the Power BI Service. Persistent filters and bookmarks in Power BI save your filter, slicer, and visual selections across sessions, but these do not apply in Power BI Desktop, which can lead to mismatched totals. To fix this, try clicking the "Reset to default" icon in the report header on Power BI Service to clear all filters and return the report to its original state. Also, check any bookmarks especially those set as default or used for navigation to make sure they are not applying filters you don’t intend. If you don’t need persistent filters, consider turning off this feature in the report settings to keep results consistent.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
Impactful Individualthx karpurapud, i'll poke around to see. There is one filter that must be on in this report and i believe we removed the ability (maybe thru hidden) for users to change that. Its an inter company flag. There is also a facility filter for which choosing other than all would be at the discretion of the user.
I never used bookmarks and we only have pro licenses (which maybe precludes using them?) but i'll poke around to see what they are and if we use them. I've read about them before but its been a while.