Count a column that has a ID that is a combination of text and numbers.

[PXJ99]

Hi all,

How to count a column that has a ID that is a combination of text and numbers.

For example: Table has IDs by month. I want to be able to count the distinct IDs by month and then plot the number count on a line chart. Could you please help. Thanks a lot.

Month    ID

Jul.          ST54

Jul.           DX98

Jul.           ST54

Aug.        DX98

Aug.        FR22

Aug.        DX98

Sep.         EY34

[v-stephen-msft · Accepted solution]

Hi @PXJ99 ,

Try the following measure:

Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER(ALLSELECTED('Table'),[Month]=MAX('Table'[Month])))

In the line chart:

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[v-stephen-msft · Accepted solution]

Hi @PXJ99 ,

Try the following measure:

Measure = CALCULATE(DISTINCTCOUNT('Table'[ID]),FILTER(ALLSELECTED('Table'),[Month]=MAX('Table'[Month])))

In the line chart:

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[PXJ99 · Accepted solution]

Thanks very much for your reply. Sorry for my late response.