Forum Discussion
Post PartisanDAX to filter multiple values in one column
As an alternative solution check the following:
https://drive.google.com/file/d/1_MdjBI60hzixXl799L80KeY3XXLEkGNQ/view?usp=sharing
Community ChampionTry:
Table = SUMMARIZE(filter('Sheet1', Sheet1[Certification] in {"Cert A"} && Sheet1[Certification] in {"Cert B"}), 'Sheet1'[User],'Sheet1'[company],'Sheet1'[Certification])
)
Though I'm not sure if that is what you are after. The && in the filter means the values should be Cert A and Cert B, as opposed to Cert A or Cert B
If it's OR you are after, try:
Table = SUMMARIZE(filter('Sheet1', Sheet1[Certification] in {"Cert A", "Cert B"}), 'Sheet1'[User],'Sheet1'[company],'Sheet1'[Certification])
)
- koorosh
I got nothing.
As you guessed I am looking for AND combination. User Name1 has Cert A and Cert B in the certification column. So I am looking for the DAX function that returns User Name 1 in its result.