cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robfen1 Frequent Visitor
Frequent Visitor

% of Sales Calculation

Hello! My first post - New to Dax, apologies if this has been answered many times before. I have a table of General Ledger data and account detail level by date. It has summary/parent tags which are driving my Matrix table in Power BI. I want to calculate % of Sales column for each month of the report. 

 

EG sum of sales products totals to 100% (total sales)

 

Cogs items totals to say 50%

 

Commission would be 10%

 

There are total of two tables which drive my Matrix report.  There is grouping relationship by account which allows me to compress the account list - this works fine.

 

I have a total sales measure but this does not account for any time period

 

Amount for Income =
CALCULATE(SUM('qryP&L'[Amount]), 'qryP&L'[Account Type] IN { "Income" })

 

happy for any guidanceSmiley Happy

 

Thanks!

 

5 REPLIES 5
diogoblunck Regular Visitor
Regular Visitor

Re: % of Sales Calculation

Hello,

 

Is pretty easy to make this, but can you spare a small section of your table, that way we can deliver the exactly measure need to be used.

Try not to send a picture, to make easy to answer.

Robfen1 Frequent Visitor
Frequent Visitor

Re: % of Sales Calculation

Transaction table: Account Type Account Class Name Date Currency Amount Foreign Amount Geography Income SPECTRUM SALES ATS SALES:Alberta Richelieu Building Specialties 6/01/18 CAD 6750 6750 Alberta Group Table Account Type Account Grouping Cost of Goods Sold COGS-ATS Assembly Cost of Sales Cost of Goods Sold COGS-Franke Canada Cost of Sales From Pivot Table/Similar to the Matrix Report Constructed in PBI 2018 Qtr2 Row Labels Jun Income 1,760,060 100% Cost of Goods Sold (854,823) 50% Expense (248,510) 10% Expanded by components Income 1,760,060 ABC 551,220 DEF 550,310 HIJ 165,832 XYZ 66,776 ....
Robfen1 Frequent Visitor
Frequent Visitor

Re: % of Sales Calculation

Well that is unhelpful

Robfen1 Frequent Visitor
Frequent Visitor

Re: % of Sales Calculation

I don't see how to add clearer content...

Any advice?


@diogoblunck wrote:

Hello,

 

Is pretty easy to make this, but can you spare a small section of your table, that way we can deliver the exactly measure need to be used.

Try not to send a picture, to make easy to answer.


 

diogoblunck Regular Visitor
Regular Visitor

Re: % of Sales Calculation

Normally I copy from a Excel sheet and paste where.

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 70 members 1,200 guests
Please welcome our newest community members: