Need help: Matrix table

Hi shakeelkhan ,

My understanding of 'all quantities' is that values of the same style are added together, regardless of attributes.

All the quantity for store1 = 6,All the quantity for store2 = 6

The Table data is shown below:

Let's assume that the store we are filtering for is 'Store 3'

Please follow these steps:

1. Use the following DAX expression to create a table

Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Style no.],
    "Store 1", SUM ( 'Table'[Store 1] ),
    "Store 2", SUM ( 'Table'[Store 2 ] ),
    "Store 3", SUM ( 'Table'[Store 3] ),
    "Store 4", SUM ( 'Table'[Store 4] ),
    "Store 5", SUM ( 'Table'[Store 5] ),
    "Store 6", SUM ( 'Table'[Store 6] )
)

2.Use the following DAX expression to create a table

Table 3 =
ADDCOLUMNS (
    FILTER ( 'Table', 'Table'[Store 3] <= 5 ),
    "all_for_store1", LOOKUPVALUE ( 'Table 2'[Store 1], 'Table 2'[Style no.], 'Table'[Style no.] ),
    "all_for_store2", LOOKUPVALUE ( 'Table 2'[Store 2], 'Table 2'[Style no.], 'Table'[Style no.] )
)

3.Use the following DAX expression to create a measure

_Store 1 = IF(ISINSCOPE('Table 3'[ATTRIBUTE]),BLANK(),MAX('Table 3'[all_for_store1]))

4.Use the following DAX expression to create a measure

_Store 2 = IF(ISINSCOPE('Table 3'[ATTRIBUTE]),BLANK(),MAX('Table 3'[all_for_store2]))

5.Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.