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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Guys,

 

based on your solutions, I inserted the "IF( NOT ISBLANK" and it did the trick

 

teste1 = COUNTROWS((FILTER(VALUES(Customers[Customer name]);IF(NOT ISBLANK([Target of calls]);[Number of calls]=[[Target of calls]]))))