Forum Discussion
Matrix not Filtering by Higher-Level Query
I have a matrix showing various measures calculating sales for specific products. The products are listed as rows, and are broken out from categories. I have a higher-level Category query that i need...
ivan_larson_ckithis is the direction of your table
which means the expanded table in DAX does
left outer with
categories to products
and
Categories-Products does left outer with Sales
Bring Category from category table and Product from Product Table in the matrix
For slicer bring category from Category table it should be able to slice
Hi smpa01,
Thank you for your suggestion. In your matrices, food products are listed under hardware, and hardware products are listed under food. Is there a way to prevent that in the structure you're suggesting?
Please change to
Sales by Alpha = CALCULATE(SUM(Sales[Amount]),FILTER('Sales','Sales'[Sales Person]="Alpha"))oruseAlpha = CALCULATE(SUMX(Sales,Sales[Amount]),FILTER(Sales,Sales[Sales Person]="Alpha"))
