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

Hi Ashish..... 

 

Well, I think I have missed something. ...... your formula did the same as the parry2k did ...

 

The thing is that there is a filter .... for Client A and Client B for instance ... As per the test I did , its summing the clients despite the filter, só te total on Sales Person is "wrong"

 

I'm sorry I cannot share database print as it's my company confidential

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    I cannot help you without seeing your file.