DAX

[Jayfemi]

Hi am looking to to create a calculated column and measure looking at the amount of times a name appears and then get a count.

i.e. "derek" but the area i am struggling with is where multiple names occour in one cell i.e. " Josh Greg Jamie Susan" is there anyway to have a dax formual look into a colunm and pick out each individual occourance and count it?

[Eric_Zhang · Accepted solution]

---

@Jayfemi wrote:

Hi am looking to to create a calculated column and measure looking at the amount of times a name appears and then get a count.

i.e. "derek" but the area i am struggling with is where multiple names occour in one cell i.e. " Josh Greg Jamie Susan" is there anyway to have a dax formual look into a colunm and pick out each individual occourance and count it?

---

@Jayfemi

Not in DAX, but in Power Query, you shall re-model your data by split and unpivot.

[Abduvali]

Hi @Jayfemi,

Just drag and drop the names and do a count on them:

Regards

Abduvali