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.
zhaya
on:
More Functional Fabric Home Page
on:
Pattern Based Visuals Formatting for accessibility
on:
Put back the Other Contacts check box for dataflow...
ToddChitt
on:
(dynamic) Connection's in Copy data activity broke...