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

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?

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

      Raw Data:

       

       

      Headder
      Apple
      Apple
      Apple
      Apple
      Apple
      Apple
      Banana
      Banana
      Banana
      Banana
      Banana
      Banana
      Grapes
      Grapes
      Grapes
      Grapes
      Mango
      Mango
      Mango
      Mango
      Mango
      abcde

       

      In the need a contribution of individual. 

      Required output as: in BI

      Row LabelsCount of Headder%
      Apple627%
      Banana627%
      Grapes418%
      Mango523%
      abcde15%
      Grand Total22 

       

       

      • ZunzunUOC's avatar
        ZunzunUOC
        Resolver III
        7 years ago

        Ok, I already understand you.

         

        You need to create two calculated columns:

         

        Count = 
var VFruit=Fruits2[Fruit]
return
CALCULATE(COUNTROWS(Fruits2);FILTER(Fruits2;Fruits2[Fruit]=VFruit))
        Result = Fruits2[Count]/SUM(Fruits2[Count])

        I have used your raw data and this is the result:

         

         

        Best Regards,
        Miguel

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