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

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
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

 

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

let me try this, and i will let you know if that works. Thanks in advance