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]))

Icon for Helper I rank

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. 🙂
  - ryan_mayu
    Super User
    5 years ago
    you are welcome