Forum Discussion
Ignoring filter context / summing items from different filter contexts
Anonymous
With above explanation you have created the Dax as required. But still why you are not able to get the result.
CAn you paste a sample picture or share a smaple data to resolve it?
Regards
Vijay Perepa
It will get me the desired result if I remove the filter context from the matrix from "only show items that belong to Current Liabilities" to "show items that belong to current liabilities and Income Statement". After that it will also map out all the accounts that belong to the Income Statement to the matrix and that's something I would not like do.
With these calculations the filter contexts collide if I simply add em up and therefore will not give me the correct result.
I can post you sample picture later on if this doesn't help you.
Anonymous
If I understood correctly you are using Internal Filters using Filters PANE , what i Suggest use Slicers (external filters) to get your desired result