Measure to use to filter data set

[Kosenurm]

Hi there, 

I want to be able to count the distinct amount of values in a table's column for when the value is "2", and have this as a measure which I can then reuse on other visuals. 

I have tried the below, but it doesn't seem to like it. Any ideas please?

DISTINCTCOUNT(CONTAINS('Bot Chat Transcript','Bot Chat Transcript'[OperatorLine], "2")

Thanks

K.

[Samarth_18 · Accepted solution]

Hi @Kosenurm ,

If I took youe question correctly then please try this:-

Measure = calculate(distinctcount(table[values]),filter(table,table[values] = 2))

Thanks,

Samarth