Forum Discussion
Tricky Counts
Hi v-yulgu-msft Ashton and Ana are also EMS account managers, it's just not in the above screenshot. There's thousands of rows. But I went with what I was originally saying my alternative may have to be. I took just the payroll questions and managers in one table, the ems questions and managers in another table. I filtered both tables by Ashton and Ana only then appended them together and renamed the [Payroll]and [EMS] fields to just read [Account Manager]. The EMS and Payroll prefixes on the [Attribute] column will let me know if responses are coming from payroll or ems questions.
So now I'm able to capture the total count of [Value] from Ana and Ashton whether they were a payroll or ems account manager:
Hi. If the first word of the [Attribute] column is what defines who you want to count the value against, can you do something like this? Which would give you a column that contains either the name of the Payroll manager or the EMS.
if Text.Start([Attribute],Text.PositionOf([Attribute]," "))="Payroll" then [Payroll] else [EMS]
You may want another column that states which one it is:
Text.Start([Attribute],Text.PositionOf([Attribute]," "))