Forum Discussion
Solved
DAX Count Question
Hey so im fairly new to working with dax and I have what I think is a pretty simple question. I have tried searching around but cant find what I need. I want a measure to count when the frequecy ...
grayscg maybe this measure will do it:
Count = VAR __checkCount = 2 RETURN SUMX ( SUMMARIZE ( Test, Test[CustomerID], "@Count", COUNTROWS ( Test ) ), IF ( [@Count] >= __checkCount, 1 ) )✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.
If you have some anonymous data, send it to me and I'll have a look for you.
What I dont understand is that it works in the example table but not in mine. I took out a sample of just the ID column, and scrambled it, to see if it work work there. It doesn't, it does the same thing where it believes every ID is distinct. Here is the table I am using.
IDNumber
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089302 |
| S0003089301 |
| S0003089301 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002002 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0003002001 |
| S0002399101 |
| S0002395201 |
| S0002395201 |
| S0002395201 |
| S0002395201 |
| S0002395201 |
| S0002395201 |
| S0002395201 |
| S0002395201 |
| S0002394901 |
| S0002384101 |
| S0002377901 |
| S0002358203 |
| S0002358203 |
| S0002358203 |
| S0002358203 |
| S0002358201 |
| S0002358201 |
| S0002358201 |
| S0002358201 |
| S0002358201 |
| S0002358201 |
| S0002358201 |
| S0002358201 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002357601 |
| S0002355501 |
| S0002353103 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |
| S0002353101 |