Forum Discussion

db042190's avatar
db042190
Icon for Impactful Individual rankImpactful Individual
1 year ago
Solved

totals dont match

Hi we have a production power bi report in the service whose FYTD total $ across 13 facilities is $xxx,xxx,065 . when i refresh its semantic model in the sevice , i see the same. when i download it...
Need Help
  • db042190's avatar
    db042190
    1 year ago

    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.   

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
1 year ago

db042190 The original discrepancy between the service and the desktop could have been due to an automatic bookmark in the service. There is an icon to reset the report filters over on the right in the header.