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
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
