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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

gracie494 Perhaps:

Measure =
  VAR __RU = MAX('Table'[Reporting Unit])
  VAR __CG = MAX('Table'[ConsGroup])
RETURN
  COUNTROWS(FILTER(ALL('Table'),[Reporting Unit]=__RU && [ConsGroup]=__CG))
gracie494's avatar
gracie494
Icon for Helper I rankHelper I
5 years ago

Greg_Deckler Thanks Greg, sadly it did'nt work. Below is the result