help with dax formula

[metal123]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Company[/TD]
[TD]Products[/TD]
[TD]Amount[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chiquita[/TD]
[TD]Bananas[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dole[/TD]
[TD]Pineapples[/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dole[/TD]
[TD]Coconuts[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chiquita[/TD]
[TD]Bananas[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chiquita[/TD]
[TD]Bananas[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dole[/TD]
[TD]Pineapples[/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chiquita[/TD]
[TD]Pineapples[/TD]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chiquita[/TD]
[TD]Coconuts[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dole[/TD]
[TD]Pineapples[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Based on the data table, I was wondering if anyone knows how to write a DAX formula where it will sum the amounts of all the dole product and the ratio of the amounts of a specific product to their total amounts.

For example,

total amount of Dole products: 12

amt of Dole Pineapples: 8

% of Pineapples to total of dole products: 8/12 or 66.67%

 

[iconiuss]

For the first value, a SUMIF statement will do.
=SUMIF(A2:A10,"Dole",C2:C10)
For the second value, you'll need SUMIFS which uses statements ie. "Dole", "Pinnapples"
=SUMIFS(C2:C10,A2:A10,"Dole",B2:B10,"Pineapples")
Then for the percentage you just subtract the pineapples from the total and format cell as percentage.
=H4/H2
If you want this as one formula just join them together.
=SUMIFS(C2:C10,A2:A10,"Dole",B2:B10,"Pineapples")/SUMIF(A2:A10,"Dole",C2:C10)

 

[iconiuss]

I realise I was too quick reading through your question and just answered the sum as a normal formula not DAX
I could be very wrong, though what I put there should still work for you, just changing the ranges
A2:A10 would be [Company] ; B2:B10 would be [Products] ; C2;C10 would be [Amount]

eg.
=SUMIFS([Amount],[Company],"Dole",[Products],"Pineapples")/SUMIF([Company],"Dole",[Amount])

 

[anvg]

Hi

=CALCULATE(SUM('MyTable'[Amount]),'MyTable'[Compay]="Dole" && ['MyTable'[Products]="Pineapples")/
CALCULATE(SUM('MyTable'[Amount]),'MyTable'[Compay]="Dole")

Regards,