Trying to calculate 5% of total row

[Ice1341]

I want to customize a percentage of the total row. How can that be accomplished? I have a column set for the specific percentage.

customer	sales	ads	damages	Total	Pct.	Broker Comm
Jan	5,000.00	(200.00)	(50.00)	4,750.00	0.05	237.5
Feb	7,000.00	(100.00)	(75.00)	6,825.00	0.05	341.25
Mar	10,000.00	(500.00)	(25.00)	9,475.00	0.05	473.75

[v-xiaotang · Accepted solution]

Hi @Ice1341 

if you want to create it by measure, use this,

Measure = MIN('Table'[Total])*MIN('Table'[Pct.])

result

and if by column, use this,

Column = 'Table'[Total] * 'Table'[Pct.]

result

Any question, please let me know. looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

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

[amitchandak]

@Ice1341 , are sales, ads, damages are in rows?

Because if they are columns 

Total = Sum(Table[sales]) + Sum(Table[ads]) +  sum(Table[damages])

% = [Total] *.05