Forum Discussion

v-manonc's avatar
v-manonc
Frequent Visitor
7 years ago

Divide one count column by total count

Hi All, Im new to BI and had a quesiton how to callucleate the total count / total count example as given   Froot       count(froot)    measure = divide[count]/sum[count]        - Not working... a...
Need Help
ZunzunUOC's avatar
ZunzunUOC
Resolver III
7 years ago

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's avatar
v-manonc
Frequent Visitor
7 years ago

Its not working

 

my raw data is apple, apple, apple, mango, mango, etc.. 

 

i taken a new measure countoftotal = count(fruits)  

now i need percentage% = [countoftotal] / sum[countoftotal]    - tried not working

 

  • ZunzunUOC's avatar
    ZunzunUOC
    Resolver III
    7 years ago

    Sorry v-manonc , is this you want?

     

     

    If not, could you explain what you need?

    • v-manonc's avatar
      v-manonc
      Frequent Visitor
      7 years ago

      I need the same, 

      in backend take the count value from (count of froot)

       

      im trying in this way - 

      Percent = [countoftransport] / sum([countoftransport])
      • ZunzunUOC's avatar
        ZunzunUOC
        Resolver III
        7 years ago

        Could you share your raw data?