Forum Discussion

burak's avatar
burak
Frequent Visitor
10 years ago
Solved

Sum of Distinct Count by column

Hello Everyone,   I am having trouble calculating sum of Distinct Count. Basically, I would like to calculate Distinct count regarding a different column. Here is the example:   Term             ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    You could create a new column that concatenates Term and ID and then create a measure that does a DISTINCTCOUNT of that column. This measure should react appropriately to slicers and such. So:

     

    Column

    TermIDs =CONCATENATE([Term],[ID])

    Measure

    DistinctTermIDs = DISTINCTCOUNT([TermIDs])
Adithya's avatar
Adithya
New Member
10 years ago

I have a set of ids 

 

1

2

3

1

1

2

4

5

5

 

and i want the id and its count

1 - 3 times

2 - 2 times

3 - 1 time

4 - 1 time

5 - 2 times

 

and i have written a measure for the same

Measure = CONCATENATE(DISTINCT(Activityx[Column1.AppId]), DISTINCTCOUNT(Activityx[Column1.AppId]))

 

 

but i am unable to get the expected result. How can i achive that?