cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
prathameshsable Regular Visitor
Regular Visitor

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

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)

 

TaskAppointmentCount
22742571909921
22742621909931
22742661909951
22742671909961
22841871911671
22841921911681
22841921911691
22842121911751
2284231 0
22842381911851
22842511911921
22846171911971

 

Many Thanks,

Prathamesh Sable

4 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

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

Hi @prathameshsable,

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

View solution in original post

prathameshsable Regular Visitor
Regular Visitor

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

Microsoft v-huizhn-msft
Microsoft

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

Hi @prathameshsable,

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

View solution in original post

prathameshsable Regular Visitor
Regular Visitor

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

Thanks Angelia....

View solution in original post

5 REPLIES 5
Microsoft v-huizhn-msft
Microsoft

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

Hi @prathameshsable,

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

View solution in original post

prathameshsable Regular Visitor
Regular Visitor

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

Microsoft v-huizhn-msft
Microsoft

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

Hi @prathameshsable,

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

View solution in original post

prathameshsable Regular Visitor
Regular Visitor

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

Thanks Angelia....

View solution in original post

prathameshsable Regular Visitor
Regular Visitor

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

Thank you so much for getting this resolved.

 

It helped a lot.

 

Regards,

Prathamesh Sable

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors