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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
jmcph
Helper III
Helper III

What if slicer problems

Hi. I am having a issues when slicing between 2 Categories in a "What if" scenario but it works fine if i only slice in 1 Category.

My Category slicer is independent from any tables named 'Slicer Category Qty'

To illustrate please see screenshots: 

 

Slicing with 1 Category (Works fine) - Selected Category: Cheeseburgers 

jmcph_0-1606737703292.png

 

However when i slice thru with more than 1 category, it reverts back to the original value: 

jmcph_1-1606737809458.png

 

Both beverage and cheeseburger are in their original value. 

 

My measure for Sales Qty Forecast : 

 

Sales Qty Forecast =
Calculate(
    [SalesQty] * (1 + [Forecast Qty Value] ) ,
              Filter ( Productlist , Productlist[Category] = Selectedvalue ( 'Slicer Category Qty'[Category Qty] ))) +
                    Calculate( [SalesQty] ,
                         Filter ( Productlist , Productlist[Category] <> Selectedvalue ( 'Slicer Category Qty'[Category Qty] )))
 
Am i missing something? Or is there something wrong with the measure? 
Thank you for helping! ! 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@jmcph , Try like


Sales Qty Forecast =
Calculate(
[SalesQty] * (1 + [Forecast Qty Value] ) ,
Filter ( Productlist , Productlist[Category] in allselected ( 'Slicer Category Qty'[Category Qty] ))) +
Calculate( [SalesQty] ,
Filter ( Productlist , not(Productlist[Category] in allselected ( 'Slicer Category Qty'[Category Qty] ))))

or
Sales Qty Forecast =
Calculate(
[SalesQty] * (1 + [Forecast Qty Value] ) ,
Filter ( Productlist , Productlist[Category] in values ( 'Slicer Category Qty'[Category Qty] ))) +
Calculate( [SalesQty] ,
Filter ( Productlist , not(Productlist[Category] in values ( 'Slicer Category Qty'[Category Qty] ))))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@jmcph , Try like


Sales Qty Forecast =
Calculate(
[SalesQty] * (1 + [Forecast Qty Value] ) ,
Filter ( Productlist , Productlist[Category] in allselected ( 'Slicer Category Qty'[Category Qty] ))) +
Calculate( [SalesQty] ,
Filter ( Productlist , not(Productlist[Category] in allselected ( 'Slicer Category Qty'[Category Qty] ))))

or
Sales Qty Forecast =
Calculate(
[SalesQty] * (1 + [Forecast Qty Value] ) ,
Filter ( Productlist , Productlist[Category] in values ( 'Slicer Category Qty'[Category Qty] ))) +
Calculate( [SalesQty] ,
Filter ( Productlist , not(Productlist[Category] in values ( 'Slicer Category Qty'[Category Qty] ))))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Works perfectly! Thank you! 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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