Forum Discussion
DAX Count Question
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.
Hi grayscg ,
Try the measure below.
Replace CustomerCount with your own table reference.
Hope this helps.
Did I help you today? Please accept my solution and hit the Kudos button.
Customer Count = CALCULATE(DISTINCTCOUNT(CustomerCount[CustomerID]), FILTER(CustomerCount,CALCULATE(COUNTA(CustomerCount[CustomerID]))>1))
This feels close. Right now that is returning a blank, where as when I flip around the > sign, it returns all the records. Something with the Distinct/Count is off. Attempting to tweak it now.
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
