Forum Discussion
Sumifs equivalent Dax not working
Hi Everyone, I keep getting errors on my Dax and nothing seems to work so I was wondering if someone has come across something similar. I have a table with all the orders and customer Id's...
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
Super User
Super UserWhat 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.