Forum Discussion
Olivier44
7 years agoNew Member
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 ...
- 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])
Greg_Deckler
7 years agoCommunity Champion
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])- Olivier447 years agoNew Member
Greg_Deckler thank you very much it seems to work!