Here's how you can do it:
- Select your table and click the 'Visualization' pane.
- In the 'Visualizations' pane, go to the 'Format' section.
- Select the 'Totals' option.
- Enable the 'Totals' to show the total in Power BI.
- That's it! You have successfully shown the total in Power BI.