Forum Discussion

Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

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 ...
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
    Tanushree_Kapse
    4 years ago

    Tried the same with KEEPFILTERS, giving the desired results.

    CALCULATE([Revenue],
    KEEPFILTERS('Product Lookup'[product_id]=3))
     
     
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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