Forum Discussion

sondhboyz's avatar
sondhboyz
Frequent Visitor
3 years ago
Solved

Number with percentage

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 R...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Pls try this

     

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

     

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

Pls try this

 

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

 

sondhboyz's avatar
sondhboyz
Frequent Visitor
3 years ago

thank you so much ahmedx