Showing results for 
Search instead for 
Did you mean: 
New Member

How to 'lock' a value in when using a Table visual

In my data, I have three Departments - New, Used, and Other.  
For Other, I need 80% of its Sales Income to be added to New's Sales Income (= New Blended Income), and 20% of its Sales Income to be added to Used's Sales Income (= Used Blended Income).

I am wanting to present a 2x2 table: Blended Sales Income by Department, with only New and Used departments showing.  


All attempts to do this filter out the Other component in the New and Used rows.  How can I effectively 'lock' the Other component in so that it is not removed by other filtering?  I trust it has something to do with KEEPFILTERS, ALLEXCEPT or the like, but can't quite get it working.


Thank you for your assistance



New Member

Your solution is just a copy paste from ChatGPT (as are your dozens of replies to other threads). FYI it doesn't work

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors