removing months in filter when there is no data

[Easley08]

Hi, 

is there a way to remove the other months in the filter if there is no data 

im currently using a dimension table for my dates here that connected in to different tables in the sample screenshot 

thanks.

[Fowmy · Accepted solution]

@Easley08 

Create a messure that counts the rows in the fact table, let's say you have fact table called 'Sales' connected to your calendar table. Add this measure to the Month name slicer and set it no t eqal to zero:

RecExist = COUNTROWS( 'Sales' )