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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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] ))))

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] ))))

Works perfectly! Thank you! 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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