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 try this measure
Count Above =
SUMX ( VALUES ( Table[Client Column] ), IF ( [Number of Calls] > [Target of Calls], 1, 0 ) )
and use it in the visual.
✨ 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 almos there .... the only thing is that the total row for the salesrep is summing the whole table ...
maybe I need to use some other parameter to achieve it .
and thanks a lot for the help already