Forum Discussion
Filter Removal - DAX
Good afternoon folks I have a calculation in DAX that I want to build very simply, Income - Expense, but I don't want the external filter Expense/Income to influence my DAX, how do I do it? Below i...
If it's the entire table that should not be impacted by that filter just remove the interaction from the slicer to the visual.
If it's only the last column use the option REMOVEFILTERS in your calculation:
it's only in the column ("measure") of the visual, but the removefilters I can even remove the external revenue/expense filter, but I need to know how much was revenue, how much was expense to subtract revenue - expense and bring it to the visual, do you know how it could be done?
Look what I did in the "Test 1" column as you told me