cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Anonymous
Not applicable

## Matrix total : total of a column in sum and the total of the other column in average

Hi everyone,

I am looking to make a matrix that can show the weight shipped per month and the share of maritime on the total for each month/year. So far so good :

The problem is that on my totals, I do find the total weight shipped (sum) but on the total SEA% I would like to have an average for the year, but this is not the case.

For the weight I used this formula Total weight formula = SUMX(File1,File1[Total Weight])

For the Sea%, I used 2 measures :

• Sea weight = CALCULATE(SUM(File1[Total Weight]), File1[Shipping type]=40)
• Sea% = DIVIDE([Sea weight],[Total weight formula],BLANK())

Do you have an idea for the average of the % of maritime to appear next to the sum of the weight?

Thank you.

Ilias

1 ACCEPTED SOLUTION
Super User
2 REPLIES 2
Community Support

Hi @Anonymous,

You can take a look at the following link to use if statement with the filters to check current row context level and replace the calculation expressions:

Clever Hierarchy Handling in DAX - SQLBI

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors