Count the amount of times a value appears in a column

[Cezenwoko]

Hello,

I need to calculate the amount of time each value appears in a particular column. The issue I'm having is that some rows have multiple values. Here's an example:

Column 1

A

B

A B D

C D B

E F

I'd like to use a dax that will calculate each time the value appears. So the count would show A =2, B =3, D =2

Thank you!

[Anonymous]

I am wanting to have a colunm that counts the rows. 
This is my data but the ID does not count from 1, 2 ,3 and so on so thought I would add a colum to have the correct count per line, hope that makes sense

[James-Harpin]

Hello @Cezenwoko 

Try creating a calculated column using the following DAX formula: 

Totals = CALCULATE( COUNT('Table'[Column1]), ALLEXCEPT('Table', 'Table'[Column1]))

[jhalverson]

you're a dawg for this one thanks for bailing me out. This should be the real accepted solution

[Anonymous]

thank you very much for the solution 🙂 

[Cezenwoko]

Hi @James-Harpin 

Thank you for your response!

I initially tried this DAX but the results come out as: A = 1, B =1, ABD = 1. As opposed to counting each value individually.

[v-easonf-msft · Accepted solution]

Hi, @Cezenwoko 

Enter a new table 'Table2' as below:

Then try measure as below:

Result = CALCULATE(COUNTROWS('Table1'),CONTAINSSTRING('Table1'[Column 1],MAX(Table2[Column1])))

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cezenwoko]

Thank you!

I was looking for a way to create this without making another table but it seems like that's impossible right now