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.

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous

 

Try measure as:

Count Above = 
IF(
    HASONEVALUE('Table'[Client]),
    IF(MAX('Table'[Number of Calls Made])>MAX('Table'[Target of Calls]),"Yse","No"),
    IF(
        SUMX(FILTER(ALL('Table'),'Table'[Sales Person]=MAX('Table'[Sales Person])),'Table'[Number of Calls Made])>SUMX(FILTER(ALL('Table'),'Table'[Sales Person]=MAX('Table'[Sales Person])),'Table'[Target of Calls]),
        "Yes",
        "No"
    )
)

Here is the output:

The demo is attached, please try it.

 

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks mate, but Almost there but at Sales Person line we should display the "count" of Yes , is it possible ?

    Also, have in mind that there were filters apllied to Clients field