Forum Discussion

gracie494's avatar
gracie494
Icon for Helper I rankHelper 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:  
Need Help
  • ryan_mayu's avatar
    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]))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

gracie494 , Try

a New column

= calculate(distinctcount(Table[ConsGroup]), filter(Table, [ reporting unit] =earlier([ reporting unit])))

gracie494's avatar
gracie494
Icon for Helper I rankHelper I
5 years ago

amitchandak Thanks, though sadly it didnt work