Forum Discussion
koorosh
Post Partisan
4 years agoDAX to filter multiple values in one column
Hello Experts, Why the following dax does not filter multiple choice in one column like "AND" operator in "IF" function? Table = SUMMARIZECOLUMNS('Sheet1'[User],'Sheet1'[company],'Sheet1'[Certif...
- 4 years ago
As an alternative solution check the following:
https://drive.google.com/file/d/1_MdjBI60hzixXl799L80KeY3XXLEkGNQ/view?usp=sharing
PaulDBrown
Community Champion
4 years agoTry:
A & B =
VAR A = CALCULATATBLE(VALUES(Sheet1[User]), Sheet1[Certification] = "Cert A")
VAR B = CALCULATATBLE(VALUES(Sheet1[User]), Sheet1[Certification] = "Cert B")
RETURN
COUNTROWS(INTERSECT(A , B))
use the measure in a visual as a filter in the filter pane an set the value to 1
koorosh
Post Partisan
4 years agoHow we can have company and date columns in Intersect table?
https://drive.google.com/file/d/1ibg2jv4ecPffXCJCqCQz4J6EjLIKxh6t/view?usp=sharing