cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors