Filtering using slicer

[Tanushree_Kapse]

Hi All,

In a matrix visual, I want to show Products, and Revenue generated and Revenue generated (for product_id =3 only).

I have a slicer of product ID having IDs from 1 to 9.

The measure I am writing for
Revenue generated (for product_id =3 only) = CALCULATE([Revenue], Table[product_id]= 3)

The issue I am having here is, whenever I select any product ids from slicer, the Revenue generated (for product_id =3 only) still shows value.

I want to show blanks or no values for this column whenever the selected product_id is other than 3.

Any help will be appreciated!

Thanks.

[amitchandak · Accepted solution]

@Tanushree_Kapse ,

if revenue is from same table you do not need filter 

[Revenue] measure should do

Try like

For selected values 

CALCULATE([Revenue], Filter( Table, Table[product_id] in allselected(Table[product_id])))

always product 3

CALCULATE([Revenue], Table[product_id]= 3)

blank when product 3 is not selected 

CALCULATE([Revenue],filter(Table, Table[product_id]= 3))

[Tanushree_Kapse · Accepted solution]

Tried the same with KEEPFILTERS, giving the desired results.

CALCULATE([Revenue],

KEEPFILTERS('Product Lookup'[product_id]=3))

[amitchandak · Accepted solution]

@Tanushree_Kapse ,

if revenue is from same table you do not need filter 

[Revenue] measure should do

Try like

For selected values 

CALCULATE([Revenue], Filter( Table, Table[product_id] in allselected(Table[product_id])))

always product 3

CALCULATE([Revenue], Table[product_id]= 3)

blank when product 3 is not selected 

CALCULATE([Revenue],filter(Table, Table[product_id]= 3))

[Tanushree_Kapse]

Thanks @amitchandak , that helped!