Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Share the download link of your PBI file and for a sample sample show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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 🙂
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Ashish_Mathur 

     

    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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      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.