Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous 

    Try below

    measure1 = Calculate(DISTINCTCOUNT(table[Equipment No]),ALLEXCEPT(table,table[year_week]), [pictures]="yes")

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous 

    Try below

    measure1 = Calculate(DISTINCTCOUNT(table[Equipment No]),ALLEXCEPT(table,table[year_week]), [pictures]="yes")

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 

      Thanks, solved!

      John