Forum Discussion
Helper ISum value by multiple dimensions in multiple tables
Hi DataScope06 ,
I have created a simple sample, please refer to it to see if it helps you.
Create a measure.
Measure = CALCULATE ( MAX ( sales_items[Qty_ordered] ), FILTER ( ALL ( 'product' ), 'product'[SKU] = SELECTEDVALUE ( sales_items[SKU] ) ) )The year table has no relationship with other tables, so we cannot output the year column.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DataScope06 ,
You need to sum the number of items ordered by product category for each customer and each year. There are so many year, Who corresponds to which year? And there cannot create relationships among the date table and other tables.
Could you also provide the desired output with the pictures like the above?
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DataScope06Anonymous I just edited the question to make it more specific. I also added an example output.