Divide one count column by total count

Question

Hi All, Im new to BI and had a quesiton how to callucleate the total count / total count example as given&nbsp;Froot &nbsp; &nbsp; &nbsp; count(froot) &nbsp;&nbsp; measure = divide[count]/sum[count] &nbsp; &nbsp; &nbsp;&nbsp; - Not working...apple &nbsp; &nbsp; &nbsp;&nbsp; 20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 22% &nbsp; &nbsp; (20/90)mango &nbsp; &nbsp; 30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 33% &nbsp;&nbsp; (30/90)grapes &nbsp; &nbsp;&nbsp; 40 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 44% &nbsp; &nbsp; (40/90)&nbsp;Where i taken a measure = count(froot)&nbsp;&nbsp;&nbsp;

zunzunuoc · Answer

Hi v-manonc , you can use the next code for calculated column, not measure:

result = Fruits[Count]/SUM(Fruits[Count])

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-manonc · Answer

Its not working&nbsp;my raw data is apple, apple, apple, mango, mango, etc..&nbsp;&nbsp;i taken a new measure countoftotal = count(fruits) &nbsp;now i need percentage% = [countoftotal] / sum[countoftotal] &nbsp;&nbsp; - tried not working&nbsp;

zunzunuoc · Answer

Sorry v-manonc , is this you want?&nbsp;&nbsp;If not, could you explain what you need?

v-manonc · Answer

I need the same,&nbsp;in backend take the count value from (count of froot)&nbsp;im trying in this way -&nbsp;Percent = [countoftransport] / sum([countoftransport])

zunzunuoc · Answer

Could you share your raw data?

Forum Discussion

Divide one count column by total count

7 Replies

Related content

Count of Occurences and divide

Divide columns

Total Count in Column

Divide two columns

Counting nulls