Forum Discussion
To exclude data below specific value from dashboard
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 , > 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
2 Replies
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 )
) + 0Thanks 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.
