Dax Formula - percentages

[Guttmann1983]

Hi, lets say, for example you have the following data....

Apple
Apple
Orange
Apple
Banana
Banana
Orange
Apple
Apple
Orange
Orange
Grape Fruit
Banana
Grape Fruit
Tangerine
Applce
Orange

and you want a dax formula to calculate what % of the total each fruit was? I understand how to do this if the data is is constant but am wondering what it would be for data that changes.. Would it just be a separate row for each total of fruit? The data I have is significant... about 10,000-15,000 rows and 35-40 columns...

 

[scottsen]

Assuming we are talking DAX / PowerPivot, this is pretty easy:

Fruity Count := COUNTROWS(Fruits)
ALL Fruity Count := CALCULATE([Fruit Count], ALLSELECTED(Fruits))
% of Fruit := DIVIDE([Fruity Count], [ALL Fruity Count])

 

[Guttmann1983]

Sorry for the delayed response. So, I am very new to dax / powerpivot. Are you saying that on the first row under my data from within the powerpivot screen, where you put in your dax formula I put in: "Fruity Count := COUNTROWS(Fruits)" ? and then the next row would be : "ALL Fruity Count := CALCULATE([Fruit Count], ALLSELECTED(Fruits))" and then the third "% of Fruit := DIVIDE([Fruity Count], [ALL Fruity Count])" ? It was giving my an error when I tried that..