gracie494Helper I5 years agoSolvedDax - 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: Show Moreryan_mayu to gracie4945 years agogracie494 pls add all(), and have a try on below DAX. calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
ryan_mayu to gracie4945 years agogracie494 pls add all(), and have a try on below DAX. calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
ryan_mayu to gracie4945 years agogracie494 pls add all(), and have a try on below DAX. calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
ryan_mayuSuper User to gracie4945 years agogracie494 pls add all(), and have a try on below DAX. calculate(distinctcount[consgroup],filter(ALL(table),[reportingunit]=max([reportingunit]))
gracie494Helper I to ryan_mayu5 years agoryan_mayu Thank you so much, it worked. 🙂 ryan_mayuSuper User to gracie4945 years agoyou are welcome
Related contentTotal Count in ColumnCount occurrences of specific values in a columnCounting nullsColumn count duplicatesDAX function to count specific text values from a column
Helper IHelper I
Helper I
