Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
191168 | 1 | |
191169 | 1 | |
2284212 | 191175 | 1 |
0 | ||
2284238 | 191185 | 1 |
2284251 | 191192 | 1 |
2284617 | 191197 | 1 |
Many Thanks,
Prathamesh Sable
Solved! Go to 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
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
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
Thanks Angelia
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
Thanks Angelia....
Thank you so much for getting this resolved.
It helped a lot.
Regards,
Prathamesh Sable
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |