"or"
1 Topic
DAX function to apply OR condition on multiple columns based on Slicers
Hi, I have multiple slicers (Location, Gender, Age, etc). I want to count all rows for any value which matches with the slicer selection. Example - If user selected Location=US, UK + Gender=Female + Age=18-24 Years, the output should be anyone who is from Locations = US or UK, OR Gender is Female OR Age is 18-24 Years. I tried below formula but not working. SelectedEmployees = CALCULATE( COUNTROWS(tblData), FILTER( 'tblData', (tblData[Location] in VALUES(tbLocations[Locations]) || tblData[Gender] in VALUES(tblGender[Gender]) || tblData[Age] in VALUES(tblAge[AgeGroups])) ) )Solved1.4KViews0likes7Comments