Forum Discussion

Apple08's avatar
Apple08
Helper IV
3 years ago
Solved

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 th...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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

Apple08's avatar
Apple08
Helper IV
3 years ago

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.