Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter Projects based on 2 criteria

I'm trying (and trying) to filter a list of Projects that are both Forks AND Knives Only (see Venn Diagram)                 Projects    Utensils    Release Proj A        Fork         ...
  • Greg_Deckler's avatar
    6 years ago

    So this is going to depend on a number of things but the general approach to this is what I call a Complex Selector. Basically, you create a measure that returns 1 or 0 based upon whatever complex logic you wish to implement. So, you might implement something like:

     

    Measure =

      VAR __Project = MAX('Table'[Project])

      VAR __Forks = COUNTROWS(FILTER(ALL('Table'),'Table'[Project] = __Project && [Utensils] = "Forks"))

      VAR __Knives = COUNTROWS(FILTER(ALL('Table'),'Table'[Project] = __Project && [Utensils] = "Knives"))

    RETURN

      IF(__Forks > 0 && __Knives > 0, 1, 0)

     

    You can then use this in your Filters pane to filter your visualization for example.