Forum Discussion
Dynamic Total Calculation Issue- Need Help on achieving the correct totals
I have a Power BI report with specific country information containing sales details for different manufacturers and segments. The report utilizes two slicers: one for selecting manufactu...
Hi Anonymous
I've put your suggestions into action and experimented with using both "SUM BY SEGMENT" and "Total Sales" as denominators for calculating the percentage. However, the outcomes haven't quite matched our expectations.
In the example I showed earlier, I only used the manufacturer and segment info. But in reality, we also have a country column.
When I use "total sales" to calculate the percentage, it's fine. But when I pick a manufacturer, the numbers go wonky. Both "total sales" and "sum by segment" act like the total sales are 22990 for manufacturer A, which isn't right. So, the percentage ends up being wrong too.