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
Super 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago
        CH/OL% = DIVIDE(SUM('Key Measures'[CH/OL],SUM('Key Measures'[CH/OL])+SUM('Key Measures'[1 HP/FL]),0))
         
        Why does this calculation not work for me? it wont pick up the table that the columns are in
        also this message comes up
         
        Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.