Hello, I am fairly new to Power BI and I calculated the percentage of column totals. I would just like to see the Black portion but keep the calculation as shown (1.92%, 2.44%, 2.53%). Getting rid of the green. Is there a way to do this?
Hi @newtobi23512,
Don't know how you calculated the measure bit you need to have a neasure that looks somethong lile this
Dealer % =
DIVIDE (
CALCULATE ( SUM ( TABLE[column] ); Table[Dealer segment group] = "Wholesaler" );
CALCULATE ( SUM ( TABLE[column] ); ALL ( Table[Dealer segment group] ) )
)
Change the table names and columns names by the ones in your table.
Not at computer so DAX syntax may have to be adjusted a little.
Regards
MFelix
Did I answer your question? Mark my post as a solution!
Don't know how you calculated the measure bit you need to have a neasure that looks somethong lile this
Dealer % =
DIVIDE (
CALCULATE ( SUM ( TABLE[column] ); Table[Dealer segment group] = "Wholesaler" );
CALCULATE ( SUM ( TABLE[column] ); ALL ( Table[Dealer segment group] ) )
)
Change the table names and columns names by the ones in your table.
Not at computer so DAX syntax may have to be adjusted a little.
Regards
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
