Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX ALL function not working with multiple filter

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 measu...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if you selected something from DimHierarchy and then using all, you will get the value summed up against that value only

I explained this case in details here :: Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Please can you elaborate with DAX because I look at the video and I'm still confused.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have watched the video and it is not what i was looking for.

    I needed the rollup from DimHierarchy table despite I am filtering category Marker from another table