Number with percentage

[sondhboyz]

Hi 

I have a sale dataset of fruits. I want to create a visual table with the total count or sum of sales with percentages in single cell, 

Fruit Name	Sale Qty	Percentage Contribution	Required This type of data
Apple	10	10%	10 (10%)
Bananas	40	40%	40 (40%)
Kiwi	50	50%	50 (50%)
Orange	10	10%	10 (10%)
Grand Total	100	100%	100 (100%)

[Ahmedx · Accepted solution]

Pls try this

Contribution Required This type of data = 
  SUM('Tatble'[Sale]) &" ("& FORMAT( SUM('Tatble'[QtyPercentage]),"Percent")&")"

[sondhboyz]

thank you so much ahmedx