To exclude data below specific value from dashboard

[Apple08]

Hi all

I have a measure to count the maximum fiscal month value, however I have to exclude those value less or equal to 100.  Please can anyone advise me how to adjust the DAX below to exclude the value 100 and under?  Thanks.

YTD Data = var Max_Data_date = MAX ( 'Data'[Date] )

var FiscalMth = Calculate ( Max ( dim_Dates[Fiscal Month] ),
                            Filter ( dim_Dates , 'dim_Dates'[Dates] = Max_Data_date )
)

return
CALCULATE ( [Count Data] ,
              filter ( dim_Dates , 'dim_Dates'[Fiscal Month] = FiscalMth )
            ) + 0

[Apple08]

Thanks amitchandak for your prompt response.  I have added in a comma after [Count Data]) at the end of the first row and it works perfectly.  Many thanks for your help.

[amitchandak · Accepted solution]

@Apple08 , > 100 based on what. One example

return
CALCULATE ( Sumx(filter(Values(dim[Customer]), [Count Data] >100), [Count Data])
filter ( dim_Dates , 'dim_Dates'[Fiscal Month] = FiscalMth )
) + 0