How to get count of one column based on refrence to other column

[Anonymous]

Hi Guys,

I am trying to get the count of repeat appointments to a particular Task. But I am not able to get the same.

See the below table, The task that I have striked through has 2 different appointments but it is being counted as 1. It should be 2. Like same task - 2 appointments.

Is there are way I can get this calculation done in POWERBI ?

Any help on this would be a lot helpful for me to calculate the no appointments taken for each task!

Please note I dont want to group the data by copying the Table & grouping it separately .

I need to either have a column or a measure created for the same as there are also some tasks where the appointment is Blank. So I need some calculation like

IF(Appointment=blank, '0' else count Task where Appointment greater than 1)

Task	Appointment	Count
2274257	190992	1
2274262	190993	1
2274266	190995	1
2274267	190996	1
2284187	191167	1
2284192	191168	1
2284192	191169	1
2284212	191175	1
2284231		0
2284238	191185	1
2284251	191192	1
2284617	191197	1

Many Thanks,

Prathamesh Sable

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Please create a calculated column using the formula below.

count=IF(Table[Appointment]=blank(),0,CALCULATE(COUNT(Table[Task]),ALLEXCELT(Table,Table[Task])))

If data type of [Task] is Text, please use COUNTA rather than COUNT.

Best Regards,
Angelia

[Anonymous · Accepted solution]

Thanks Angelia

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Have you resolved your issue? If you have, please mark the helpful or right reply as answer, so more people will benefit from here.

Best Regards,
Angelia

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Please create a calculated column using the formula below.

count=IF(Table[Appointment]=blank(),0,CALCULATE(COUNT(Table[Task]),ALLEXCELT(Table,Table[Task])))

If data type of [Task] is Text, please use COUNTA rather than COUNT.

Best Regards,
Angelia

[Anonymous · Accepted solution]

Thanks Angelia

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Have you resolved your issue? If you have, please mark the helpful or right reply as answer, so more people will benefit from here.

Best Regards,
Angelia

[Anonymous · Accepted solution]

Thanks Angelia....

[Anonymous]

Thank you so much for getting this resolved.

It helped a lot.

Regards,

Prathamesh Sable