Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

COUNT based on a measure

Hello Guys, I'm brand new to Power BI and DAX and need some Help to execute the followin.   I have the following table   Client Target of Calls Number of Calls Made Above Target Sales Pe...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    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.⚡

  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Try this measure

    Measure1 = countrows(filter(values(Customers[Customer name]),[Number of calls]>[Target of calls]))

    Drag Measure 1 to a card visual.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous I'm still confused, you need to show the result using my measure, paste sample data, show the result what is working and what is not working? I'm shooting here in the dark with very little information