Forum Discussion

carebear88's avatar
carebear88
Frequent Visitor
5 years ago
Solved

How to count ID only once

Hi!   I need some help getting my data to only count once. The data has one unique ID number, but this number can have several rows due to a collum called consequences. This is because the ID can h...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi! Try to create a measure: 

    Count ID once = DISTINCTCOUNT('TableName'[Caseno])

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi! Try to create a measure: 

Count ID once = DISTINCTCOUNT('TableName'[Caseno])