Count duplicated values

[datanau001]

Dear all,

I would like to create a column that shows for each line of a ticket number the total times this ticket was handled by a support group.

For this, I have three columns:

• “Touching’s per group” (total times a ticket was handled by the group);
• “Audit Next Owner Group” (group that handled the ticket)
• “SR_Number” (ticket number)

However, I’m managing to get this result ( tried to use countx, distinctcount).

Would be possible to have you support on this question?

Please, find attached a print with the above mentioned columns.

E.g: the result concerning to group “ZZZ_GTT- AMT – TSC - Content_Deleted” would be 2.

Thank you.

Marcelo

[Stachu · Accepted solution]

wouldn't it be better to use measure instead of column? that way you could present the correct number in the visuals, with the column it would add 2+2 and show 4 in the Table/Matrix visuals (unless you don't aggregate)
How do you want to present that data in the end?

[v-lili6-msft · Accepted solution]

HI, @datanau001

After my test, you may try this formula as below:

Touching’s per group = CALCULATE(COUNTA('Table'[Audit]),FILTER('Table','Table'[SR_NUMBER]=EARLIER('Table'[SR_NUMBER])&&'Table'[Audit]=EARLIER('Table'[Audit])))

If it is not your case, please share some data sample and expected output. Do mask sensitive data before uploading.

Best Regards,

Lin

[datanau001]

Hello Lin,

Your formula resolved the issue.

Thank for the support.

Marcelo

[themistoklis]

@datanau001

First a new column and not measure using this formula:

Concatenated_Values = CONCATENATE(CONCATENATE('Table'[Audit Next Owner Group],'Table'[Touchings per group]),'Table'[SR_NUMBER])

Then create a measure to count the values from this new column:

COUNT VALUES = COUNT('Table'[Concatenated_Values])

[Stachu · Accepted solution]

wouldn't it be better to use measure instead of column? that way you could present the correct number in the visuals, with the column it would add 2+2 and show 4 in the Table/Matrix visuals (unless you don't aggregate)
How do you want to present that data in the end?