cancel
Showing results for
Did you mean:
Frequent Visitor

## DAX CALCULATION % OF SALES

Hi guys,

I do not get this to work.

I have created a hiearchy where the top level shows SALES, COGS,  PERSONNEL COSTS, OTHER EXTERNAL COSTS.

If you drill down, you can see all the accountnumbers tied to these classificaitons.

I am trying to create a DAX calculation which shows the % of Sales.

"% of Sales = SUM(Table1[Sales]) / CALCULATE(SUM(Table1[Sales]); Table1[Type] = "SALES")"

However, this works when looking at the top level, but when drilling down it no longer works.

Any ideas??

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

## Re: DAX CALCULATION % OF SALES

Putting the SUM in the values area, and "Show as percent of" grand total works. But I want to "show percent of" Sales which is the top row called "1. Intäkter".

So I put SUM in the values field and then I choose "show percent"  of  "1. Intäkter" a.k.a Sales.

This works until you want to drill down in the pivot table :/

Thanks for trying to help!

2 REPLIES 2
Super User

## Re: DAX CALCULATION % OF SALES

I would try just a simple SUM and then in the values area click the drop down on the field and choose "Show as" | "Percent of grand total". Otherwise, I would try:

`% of Sales = SUM(Table1[Sales]) / CALCULATE(SUM(Table1[Sales]); ALLEXCEPT(Table1,[Type]))`

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Highlighted
Frequent Visitor

## Re: DAX CALCULATION % OF SALES

Putting the SUM in the values area, and "Show as percent of" grand total works. But I want to "show percent of" Sales which is the top row called "1. Intäkter".

So I put SUM in the values field and then I choose "show percent"  of  "1. Intäkter" a.k.a Sales.

This works until you want to drill down in the pivot table :/

Thanks for trying to help!

Announcements

#### 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.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 263 members 3,038 guests
Recent signins: