Forum Discussion
Anonymous
6 years agoNot applicable
calculating correct quantity
good day all,
I have the following table:
I am looking for a measure which gives me the quantity of containers from which we took pictures.
the outcome should be as follows:
2020 - 34: 1 (container)
2020 - 34: 1 (container)
Thanks!
John
- Anonymous6 years ago
HI Anonymous
Try below
measure1 = Calculate(DISTINCTCOUNT(table[Equipment No]),ALLEXCEPT(table,table[year_week]), [pictures]="yes")
2 Replies
- AnonymousNot applicable
HI Anonymous
Try below
measure1 = Calculate(DISTINCTCOUNT(table[Equipment No]),ALLEXCEPT(table,table[year_week]), [pictures]="yes")
- AnonymousNot applicable
Anonymous
Thanks, solved!
John