topic Table calculating total row same way as other rows in DAX Commands and Tips

Table calculating total row same way as other rows

MariaSal — Tue, 10 Oct 2023 07:52:08 GMT

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%?

Re: Table calculating total row same way as other rows

Anonymous — Thu, 12 Oct 2023 07:08:30 GMT

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.

Re: Table calculating total row same way as other rows

MariaSal — Wed, 18 Oct 2023 07:57:33 GMT

Hey Rico!

This worked, many thanks!

Br,Maria