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 ...
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

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity 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