Forum Discussion
Anonymous
2 years agoNot applicable
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...
Anonymous
2 years agoNot applicable
Hi Anonymous ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create measures
SUM = SUM('Table'[Sales])SUM BY SEGMENT =
CALCULATE(
[Total Sales],
REMOVEFILTERS('Table'[MANUFACTURER]),
VALUES('Table'[SEGMENT])
)Total Sales =
CALCULATE(
SUM('Table'[Sales]),
ALL('Table'[MANUFACTURER])
)Percentage = [SUM]/[SUM BY SEGMENT]
These will calculate the percentage of the same SEGMENT that each MANUFACTURER accounts for, and if you want to display the total even after selecting the MANUFACTURER, you can do so by simply selecting the option in the MANUFACTURER
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly