DAX help

Hey dilumd,

understand! With your current data model (just one table) this will become a nightmare, for this reason I recommend to adjust your datamodel to this

I set the Cross filter direction between table1 and "Category2", because category2 seems less important to me than category1, maybe I err. But this allows that the content of the slicer for "Category 2" based on the coresponding table, namely "Category 2" reacts to selections of the slicer Category 1
Category1 --> Table1 <--> Category2

 
I created the tables Category 1 and Category 2, using these simple DAX statemens, e.g. Category 1:

Category 1 = 
VALUES(Table1[Category1]) 

Then I created a measure like so:

Quantity_T = 
CALCULATE(
    SUM(Table1[Qty])
    ,ALL('Category 2'[Category2])
)

This results to this report - please be aware that the content of the Category slicers is coming from the category tables:

Hopefully this is what you are looking for, or at least gives an idea, of course the new measure returns 19, if nothing from Category 1 is selected :-)

Regards,

Tom