Forum Discussion
Complex Matching varying slicer interactions
- Anonymous2 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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.