Forum Discussion

Mr_Glister's avatar
Mr_Glister
Advocate II
2 years ago
Solved

DAX distinct count with filter condition

I have an issue with something that I thought would be easy.    Below is a sample of my data. I would want to create a DAX measure that counts the number of companies (distinct!) that have >= 10 It...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Mr_Glister ,

     

    I made simple samples and you can check the results below:

    Total Count = var _t = ADDCOLUMNS('Table',"total",SUMX(FILTER(ALL('Table'),[Week]=EARLIER([Week])&&[Company]=EARLIER([Company])),[Item sold]))
RETURN CALCULATE(DISTINCTCOUNT([Company]),FILTER(_t,[Total]>=10))

     

    An attachment for your reference. Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Mr_Glister's avatar
Mr_Glister
Advocate II
2 years ago

Hi Daniel,

is this supposed to be Sum() of item sold?

"sold" , [item sold]

 

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Mr_Glister 

sorry for the late reply . it seems that there is a problem with the platform.  i m getting no notifications .

 

 

correct. 

this is sum(item sold) 

 

let me know if you need any help .

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠