Forum Discussion
Sumifs equivalent Dax not working
Super UserHi,
Share some data and show the expected result.
Hi,
I have attached below an excel example of my data and what they look like.
 
what i want to get frm this calculation that I am trying to do is to be able to get a bar chart showing number of customers that has 5 purchases on theirs records,6,7,10,20 etc.in order to be able to see how many purchases do returning customers tend to have.
- Ashish_Mathur
Hi,
Share the download link of your PBI file and for a sample sample show the expected result.
Hey Guys,
UPDATE: I managed to get it work 🙂
Its seems that due to size of the rows the calculations werent working well but I created an extra field with an if statement which would class the row (I created the extra column because there were some zero value orders that I needed to keep) and then I filter the data though Power query saved and applied,and did an extra column with the below formula,this sorted my issue.
lets see result = CALCULATE(COUNT(ORDERS_NEW[NAME]),ALLEXCEPT(ORDERS_NEW,ORDERS_NEW[EMAIL]))Thank you everyone for your help 🙂I cant share my PBIX files as it contains confidential data,hence I attached a sample of the data on excel.
In regards ro the desired result,i have described it quite clearly I belive,but if there is something confusing could you please tell me and maybe I can try to explain it.If I could put the desired result on PBIX file I would but in that case I wouldnt need to publish my question.
- Ashish_Mathur
What do you mean by - "number of customers that has 5 purchases on theirs records,6,7,10,20 etc.". On a dummy dataset, show this expected result.
Furthermore, i am not going to create a dataset and also solve your question. The least i would expect of you is to share a dummy (but representative) dataset and show the expected result on that dummy dataset.