Forum Discussion

Olivier44's avatar
Olivier44
New Member
7 years ago
Solved

Count values for a specific date

Hi everyone,    I have been searching for a solution for several days now but still couldn't find an answer to my issue. I hope you guys can help?   In my data source I have a list of assortment ...
  • Greg_Deckler's avatar
    7 years ago

    You should be able to create a measure like:

     

    Measure =
    VAR __maxDate = MAX([Date])
    VAR __table = FILTER('Table',[Date] = __maxDate && [Product in store] = TRUE())
    RETURN
    COUNTX(__table,[Product])