Question about slicers

[Anonymous]

Hi,

I have two table named Gender and Subclass, the gender class has two observations namely "Male" and "Female". The Subclass table has 4 observations called "women's casual", "women's jeans", "men's casual" and "men's jeans". 

I have made two slicers on my dashboard using the gender table and subclass table, I want the user to be able to select the gender from the gender slicer and the second slicer for subclass should only show the 2 values relevant for that gender, for example if the user selects "female" from the gender slicer the subclass slicer should only show "women's casual" and "women's jeans". Any suggestions would be highly appreciated. 

Thanks.

[PaulDBrown · Accepted solution]

Ok. Create a measure to use as a filter in the filter pane for each slicer with:

Filter slicers =
COUNTROWS ( RELATEDTABLE ( 'Sales' ) )

Add the measure to the filter pane for each slicer and set the value to greater or equal to 1

[Anonymous]

Hey, thank you so much, that worked.

[PaulDBrown]

How is the model set up?

[Anonymous]

@PaulDBrown I have a main sales table with thousands of observations, and I have made two tables from this main sales table using the DISTINCT command for gender and the subclass table.