Reverse Table Filters?

[Anonymous]

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 category, so I can isolate the delta or positive/negative effect of a category

For Example: I can already track the success rate when I use Part A. However, because multiple parts are used at a time, I want to also track the success rate of all trials without Part A, and subtract them to get Part A's "success delta" if that makes sense. Is there any way to do this within a table? Maybe make a scatter plot with Success Deltas and Usage Rates? Thanks!

[Greg_Deckler]

@Anonymous - Inverse Aggregator - https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266#M91

[Greg_Deckler]

@Anonymous - Did the inverse aggregator work for you? Please @ me to let me know.

[amitchandak]

@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.