Forum Discussion

s45kougo's avatar
s45kougo
Helper I
6 years ago
Solved

Filtering within a VALUES function based on another field

Hi all - hoping someone can help me with this (my first plea for help!)   I'll give an anonymised example of what I need to do - the real version is obviously a bit more complicated! I have a tabl...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Another approach is to use CALCULATETABLE(VALUES(Table[Fruit]), Table[Colour] = "green").

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

DataZoe's avatar
DataZoe
Microsoft Employee
6 years ago

s45kougo Not sure I understand the scenario here, but my first thought was this:

 

Slicer =

var fruit = CROSSJOIN(ROW("Type","Fruit"), filter(VALUES('Table'[fruit]),'Table'[Colour]="Green"))

var vegetable = CROSSJOIN(ROW("Type","Vegetable"), VALUES('Table'[Vegetable]))

return UNION(fruit,vegetable)

s45kougo's avatar
s45kougo
Helper I
6 years ago

DataZoe I'd hoped that this would work as I was thinking along the same lines.  However, because VALUES returns a single column, [Colour] cannot be the second parameter in the FILTER function.  Many thanks for replying anyway 🙂