Forum Discussion

Redacted_VAR's avatar
Redacted_VAR
Icon for Helper I rankHelper I
2 years ago
Solved

Complex Matching varying slicer interactions

So I'm really struggling with this one, i'm not even sure it's possible. I've used some dummy data below to illustrate my problem. in essence I have two tables - one describing the drink, including n...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Redacted_VAR 

     

    Thanks for the reply from MFelix .

     

    Redacted_VAR , please try the following method.

     

    Use the fields in Table2 as Salesperson Slicer

     

    Create a new table as Drink slicer

    Drinktable = VALUES(Table1[Drink])

     

    no relationship between these tables

     

    Create two measures as follow

    Has Bought Drink = 
VAR _Drink = CALCULATE(MAX(Table1[Drink]), FILTER(Table1, [first Customer Name] = SELECTEDVALUE(Table2[Customer Name])))
RETURN
IF(_Drink = SELECTEDVALUE(Drinktable[Drink]), "Yes", "No")

     

    Is In right Industry = IF(MAX(Table2[Customer Industry]) = [TopIndustry], "Yes", "No")

     

    Output:

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Redacted_VAR ,

 

For this you need to remove the context filter from the sales person your measure would be similar to this:

 

TopIndustry = 
Var _maxValue =
Maxx(Values(Table2[Customer Industry]),[Rank])
RETURN
CALCULATE(
    Min(Table2[Customer Industry]),
    Filter(Values(Table2[Customer Industry]),[Rank]= _maxValue) && REMOVEFILTERS(Table2[SalesPerson])
)