Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AH1988
Frequent Visitor

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

 

 

1 REPLY 1
AH1988
Frequent Visitor

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors