Forum Discussion

Kosenurm's avatar
Kosenurm
Regular Visitor
4 years ago
Solved

Measure to use to filter data set

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.

 

 

Need Help
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Kosenurm ,

     

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

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

     

    Thanks,

    Samarth

     

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi Kosenurm ,

     

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

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

     

    Thanks,

    Samarth