Forum Discussion
Count YTD Sales above specific value
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.⚡
Super Userpowerbanana try this
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.⚡
Thanks for the prompt feedback. Unfortunately, your proposed solution has the same issue has my original measure. It seems that the filter is applied on the Sales_Sum values, but not the Sales_YTD.
I used your proposal in a similar & larger table, but the count is still incorrect (see below November and October are missing counts). Any other ideas?