Forum Discussion

grayscg's avatar
grayscg
Advocate I
3 years ago
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 ...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    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.

parry2k's avatar
parry2k
Super User
3 years ago

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.

grayscg's avatar
grayscg
Advocate I
3 years ago

This works! Thank you! I do not understand enough about dax to know how it works, but this gives me some new functions to study.