Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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!
@Anonymous - Inverse Aggregator - https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266#M91
@Anonymous - Did the inverse aggregator work for you? Please @ me to let me know.
@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.