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