Forum Discussion
JNelson
Helper II
Helper IIPercentage calculated column
Hello! I need some help with a Profit % calculated column. I think it is a very simple answer that I can't seem to see. T_Profit = Table1[T_Revenue]-Table1[T_Cost] T_Profit% = DIVIDE(Table1[...
Yes, you should use measures instead. When you add a column to a visual like that Power BI will automatically create implicit measures anyway, better to do it yourself. You can also use the measures you define as building blocks for further measures, e.g.
Revenue = SUM(Table1[T_Revenue]) Cost = SUM(Table1[Cost]) Profit = [Revenue] - [Cost] Profit % = DIVIDE( [Profit], [Cost], 0)
johnt75
Super User
Super UserYes, you should use measures instead. When you add a column to a visual like that Power BI will automatically create implicit measures anyway, better to do it yourself. You can also use the measures you define as building blocks for further measures, e.g.
Revenue = SUM(Table1[T_Revenue])
Cost = SUM(Table1[Cost])
Profit = [Revenue] - [Cost]
Profit % = DIVIDE( [Profit], [Cost], 0)