"slicers"

2 Topics

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])) ) )
Solved
Kosh
9 months ago Place DAX Commands and Tips
1.4KViews
0likes
7Comments
non-default value in 'greater than' slicer removes removefilters
Hi, I have a table with dataset (below) In the table Production values are duplicated for each year, region, Line, primary_product. 1. I created measure to calculate production accross year, region, Line, primary_product and ignore product and unit slicers . Production_Meets = CALCULATE( SUMX( SUMMARIZE( Sheet1, Sheet1[year], Sheet1[region], Sheet1[Line], Sheet1[primary_product], "UniqueProduction", MAX(Sheet1[production]) ), [UniqueProduction] ), REMOVEFILTERS(Sheet1[unit], Sheet1[product]) ) Issue: When Production 'Greater than' slicer is set to default (30), the measure shows correct value 213 (production value for bikeA primary_product across all products - frame , wheel) When When Production 'Greater than' slicer is set to non default (0,1,2..29,31..), the measure shows correct value 213. Then the Production_meet loses Removefilter ability and shows 180 (production value for bikeA primary_product across all products - frame only) If I set "Value filter behavior" in Model properties as Independent, then the formula will work, but I do not want to make this change on model level, as it affects other reports. How to fix production_meets calculations? year region Line primary_product product unit production 2024 NA 123 bikeA wheel % 100.00 2024 NA 123 bikeA wheel kg 100.00 2024 NA 123 bikeA bikeA % 100.00 2024 NA 123 bikeA wheel each 100.00 2024 NA 123 bikeA frame % 100.00 2024 NA 123 bikeA frame kg 100.00 2024 NA 123 bikeA frame lb 100.00 2024 NA 123 bikeA frame each 100.00 2024 NA 123 bikeA frame tn 100.00 2024 NA 567 bikeA wheel % 50.00 2024 NA 567 bikeA wheel kg 50.00 2024 NA 567 bikeA wheel lb 50.00 2024 NA 567 bikeA bikeA % 50.00 2024 NA 567 bikeA frame % 50.00 2024 NA 567 bikeA frame kg 50.00 2024 NA 567 bikeA frame lb 50.00 2024 NA 567 bikeA frame each 50.00 2024 NA 567 bikeA frame tn 50.00 2024 NA 789 bikeA wheel % 30.00 2024 NA 789 bikeA wheel kg 30.00 2024 NA 789 bikeA wheel lb 30.00 2024 NA 789 bikeA wheel each 30.00 2024 NA 789 bikeA bikeA % 30.00 2024 NA 789 bikeA frame kg 30.00 2024 NA 789 bikeA frame lb 30.00 2024 NA 789 bikeA frame each 30.00 2024 NA 789 bikeA frame tn 30.00 2024 NA 333 bikeA wheel % 33.00 2024 NA 333 bikeA wheel kg 33.00 2024 NA 333 bikeA wheel lb 33.00 2024 NA 333 bikeA wheel each 33.00 2024 NA 333 bikeA bikeA % 33.00
Solved
Julia1234
1 year ago Place DAX Commands and Tips
892Views
0likes
4Comments