cancel
Showing results for
Did you mean:
Helper I

## Trying to calculate 5% of total row

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
1 ACCEPTED SOLUTION
Community Support

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

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.

2 REPLIES 2
Community Support

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

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.

Super User IV

@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

Proud to be a Super User!

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors