I have 3 dimension and 1 fact tables. I want calculate the sum(Fact[Value]) that filter through the dimension tables except that one dimension table should ignore the filter context, see my dax measure below :
Measure = CALCULATE( SUM( FACT[Value]), FILTER(DimCategory, DimCategory[Category] = "Marker")
, FILTER(DimDept, DimDept[Dept] =1 , ALL(DimHierarchy) )
The ALL(DimHierarchy) is not ignoring the Filter context in DimHierarchy table. I need other filters of Marker and dept =1 to filter through but the dimhierarchy should return grandtotal of the table .
How can i make this dax working. thanks