There is currently no way to retrieve correct totals for the table dataviewmapping when datareductionalgorithm is used.
The returned total is of the loaded data.
This has been confirmed to me by the Custom Visuals team.
Quoting the response I received today:
"Answering your question — no, there isn’t any undocumented or hidden method to display totals for the entire dataset when using paginated data in a table layout. The built-in Power BI Table visual calculates totals internally through the host’s DAX engine, which isn’t accessible to custom visuals.
At the moment, these are no special workarounds, the possible options would be:
Providing a pre-aggregated total from your data model (for example, via a DAX measure or calculated table) and pass it to the visual as a separate field.
Using a non-paginated dataView for smaller datasets where you can safely compute totals within the visual itself."
This prevents building certain visuals like true table visuals.
on:
Improve error message when dataset mixes cloud and...
on:
Org apps per app and workbooks with custom message...
on:
Deployment pipeline rule for data factory pipeline...
on:
Epic Idea: Show visual dependencies for bookmarks
dm-p
on:
Allow standard Focus Mode for custom visuals that ...