What if slicer problems

Question

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

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

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! !

amitchandak · Accepted Answer

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

Forum Discussion

What if slicer problems

2 Replies

Related content

Problem with field parameter and empty slicer

Slicer Problem

Logic problem?

Slider problems

Slicer problems