Forum Discussion

Redacted_VAR's avatar
Redacted_VAR
Helper 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.

Redacted_VAR's avatar
Redacted_VAR
Helper I
2 years ago

Hey,

 

nope still returns the same as the above - no change from before.

MFelix's avatar
MFelix
Super User
2 years ago

Hi Redacted_VAR ,

 

Without the model it's difficult to give you a correct answer.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.