Forum Discussion

Adithya's avatar
Adithya
New Member
10 years ago
Solved

DAX for getting distinct item and its count

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?

  • v-chuncz-msft's avatar
    v-chuncz-msft
    10 years ago

    Adithya,

     

    Based on my test, here is one way for your reference.

    Measure =
MAXX ( Table1, Table1[Column1] ) & " - "
    & COUNTX ( Table1, Table1[Column1] )
    & " time"
    & IF ( COUNTX ( Table1, Table1[Column1] ) > 1, "s", "" )

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    10 years ago

    Adithya,

     

    Based on my test, here is one way for your reference.

    Measure =
MAXX ( Table1, Table1[Column1] ) & " - "
    & COUNTX ( Table1, Table1[Column1] )
    & " time"
    & IF ( COUNTX ( Table1, Table1[Column1] ) > 1, "s", "" )