Forum Discussion
COUNT based on a measure
Anonymous not sure what does that means but I guess it answered your original question, no?
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi,
Try this measure
Measure1 = countrows(filter(values(Customers[Customer name]),[Number of calls]>[Target of calls]))
Drag Measure 1 to a card visual.
Super UserAnonymous not sure what does that means but I guess it answered your original question, no?
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k part of It, I can make the YES or NO but the part in red below its summing all the register in client table, despite the filterw I'm using in the view
| Client | Target of Calls | Number of Calls Made | Above Target |
| Sales Person 1 | 18 | 19 | 1 |
| Client A | 10 | 9 | No |
| Client B | 8 | 10 | Yes |
| Sales Person 2 | 13 | 13 | 1 |
| Client C | 5 | 6 | Yes |
| Client D | 7 | 7 | No |