Table calculating total row same way as other rows

[MariaSal]

I have created a new column to my table with calculation: Rate = 1-Table[SALES X]/(Table[SalesY]

As a result I get this table:

ID	Rate	SALES Y	SALES X
1	59,79 %	4004,78	1610,23
2	80,38 %	8112,50	1591,50
3	56,87 %	7968,50	3437,00
Total	197,04 %	20085,78	6638,73

How can I get the last line (Total) to calculate the same way as for the other rows so 1-Sales X/SalesY 1-6638,73/20085,78=66,95%?

[Anonymous · Accepted solution]

Hi @MariaSal ,

According to your statement, I think the [Rate] may be a calculated column. When you add this column into visual, it will only show aggregated data by function like SUM()...  and so on.

I suggest you to try a measure to achieve your goal.

Rate Measure =
1 - DIVIDE ( SUM ( 'Table'[SALES X] ), SUM ( 'Table'[SALES Y] ) )

Result is as below.

Best Regards,
Rico Zhou

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

[MariaSal]

Hey Rico!

This worked, many thanks!

Br,Maria