Share within a segment

[Anonymous]

I'm struggeling to find the right dax code to calculate a share of manufacturer within a category. See example below of my matrix table:

I have a Dim table with manufacturers linked to brands and categories.

My current code gives me a result of 100% on every single line:

Company total share mat = CALCULATE('Sales data total'[MAT Value])/CALCULATE('Sales data total'[MAT Value],FILTER(category_All_Categories_sales_r,category_All_Categories_sales_r[Category]<> BLANK()))

[Mahesh0016]

Hello @Anonymous ,

i hope it is helpful for you.

[Mahesh0016]

please can you share expected result snapshot.

[Anonymous]

Expected results would be that the last column is a calculation of mat value by row devided by the total sum in bold. So after column 403.130 there should be 0.029 (instead of 1)