Forum Discussion

Icon for Helper I rank

Helper I

5 years ago

Solved

Dax - Count in Column based on a specific field

Hello, How do I perform a count of the Cons group in each specific reporting unit. The output I am trying to achieve is in green:

ryan_mayu
5 years ago
gracie494

pls add all(), and have a try on below DAX.

calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))

Icon for Super User rank

Super User

5 years ago

maybe try

calculate(distinctcount[consgroup],filter(table,[reportingunit]=max([reportingunit]))

gracie494
Helper I
5 years ago
ryan_mayu sadly it didnt work, just returns a 1
- ryan_mayu
  Super User
  5 years ago
  gracie494
  
  pls add all(), and have a try on below DAX.
  
  calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
  - gracie494
    Helper I
    5 years ago
    ryan_mayu Thank you so much, it worked. 🙂