Forum Discussion
Filter Projects based on 2 criteria
- 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.
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.