Forum Discussion
divison calculation for the same column
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]))
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
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.
- 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 inalso this message comes upToo many arguments were passed to the SUM function. The maximum argument count for the function is 1.
Hi Anonymous ,
Sorry, not very clear, can you provide me with pbix file? Remember to hide private data.
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.
Hi
I've used this calculation however the values are under the wrong headings
CH/OP result is more likely to be the result for HP/FL
How can i switch the two so the results are more accurate