Forum Discussion

fiorela's avatar
fiorela
Icon for Helper I rankHelper I
6 years ago
Solved

distinct count and group by

Hi there !   i would like your help on this. I dont know how to search and how to make the following calculation.   I have the following columns: User   Session  Category Juan    A             ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi fiorela 

    you dont need any additional columns, just try a measure

    countDISTINCTCategory = calculate(DISTINCTCOUNT('Table'[Category]), ALLEXCEPT('Table', 'Table'[User]))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

     

divsforeal's avatar
divsforeal
Frequent Visitor
4 years ago

hey

 

How to get this in power Query.

 

Thanks