Forum Discussion
Filtering using slicer
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.
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))
Tried the same with KEEPFILTERS, giving the desired results.
CALCULATE([Revenue],KEEPFILTERS('Product Lookup'[product_id]=3))
3 Replies
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))
Thanks amitchandak , that helped!
Tried the same with KEEPFILTERS, giving the desired results.
CALCULATE([Revenue],KEEPFILTERS('Product Lookup'[product_id]=3))