Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This is what it looks like on Excel 

i need this on power bi 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Based on what I see in excel

     

    CH/OL % = divide( sum(Table[CH/OL]), Sum(HP/FL)+sum(Table[CH/OL]))

     

    HP/FL % = divide( sum(Table[CH/OL]), Sum(HP/FL)+sum(Table[CH/OL]))

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      That is closer however, the values CH/OL are in the column called doc type in the data set which is why I need a measure which picks up "ch" and "ol" and calculating all of the amount financed for those 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

         

        Can you provide the pbix of the sample data? I don't quite understand what the doc type is. The attachment is the pbix file I created by myself, you can refer to it.

         

         

        Best Regards,

        Stephen Tao

         

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