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