Forum Discussion
Reverse Table Filters?
I have a table that filters by multiple categories, so when I insert data it automatically filters. I’m wondering how I can reverse this in a measure that averages/sums all the data WITHOUT xyz ...
Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If value1 is selected in col1 this will give other then value1
new measure =
calculate([measure], filter(All(Table), not(Table[col] in values(Table[col]))))
or
new measure =
calculate([measure], filter(All(Table), not(Table[col] in allselected(Table[col]))))
Appreciate your Kudos.