calculating correct quantity

[jwi1]

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

[pranit828 · Accepted solution]

HI @jwi1 

Try below

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

[jwi1]

@pranit828 

Thanks, solved!

John