Forum Discussion
Solved
Count YTD Sales above specific value
Hi all, Very new with Power BI and hope someone can help me. I am trying to count the number of clients that have YTD sales above a certain threshold. I have the following two tables: First T...
powerbanana you didn't used the same DAX expression what I gave to you, not sure what else to tell
CountFilter_YTD = COUNTX ( VALUES ( Table[Furit] ), IF ([Sales_YTD]>40,1) )✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
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.⚡
My bad, I tried with the correct DAX expression and it worked! Thank you very much 😃