Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI Reverse Slicer (Lookup Returning Multiple Values)

Hello,   I would like to build a reverse slicer in Power BI based on the two tables below: Product Category Product Name A Pencil A Pen  A Ruler B Pencil B Watch C Stic...
DAX
Filter
Need Help
Reverse Slicer
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Create this measure and assign it to the visual filter of the matrix and set it equal to 1. The file is attached below my signature.

    Filter Measure = 

var __product = SELECTEDVALUE('Product Name'[Product Name]) 
var __category =  SELECTEDVALUE('Product Category & Name'[Product Category])
var __prodcat = 
    CALCULATE(
        MAX('Product Category & Name'[Product Category]),
        'Product Category & Name'[Product Name] = __product
    ) <> __category
return
    INT(__prodcat)

     

     

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Create this measure and assign it to the visual filter of the matrix and set it equal to 1. The file is attached below my signature.

Filter Measure = 

var __product = SELECTEDVALUE('Product Name'[Product Name]) 
var __category =  SELECTEDVALUE('Product Category & Name'[Product Category])
var __prodcat = 
    CALCULATE(
        MAX('Product Category & Name'[Product Category]),
        'Product Category & Name'[Product Name] = __product
    ) <> __category
return
    INT(__prodcat)