Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

DAX help needed

Hi everyone,    I have a dax query that works very slow, and my data model consist of 1 fact table as well as 2 basic dimension like dim date,    can you suggest an optimized code for the dax que...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago
idproductproduct_idamounts_id
100-4024449860301,910668506
100-4024449860301,910668868
100-4024449860301,910670033
100-4023063296200199334
100-4023063321202,71866829
100-4023063351205,878233
100-4023063537200,8199336
100-402306390621211889161
100-4023063997211,41984698
100-4023064113215,51992505
100-402306414321077493
100-40230641552110,910037981
100-40230641802118,41994162
100-4023064180212,72015940
100-4023064180223,22034646
100-4023064287221,310613124
100-4023064570221,7182786
100-4023064570221,7183063
100-4023064735225,51994150
100-4023064946224,610289201
100-4023065082224,910038215
100-4023065082221,710038252
100-4023065116220,410037979
100-4023065148220,7199364
100-4023065287220,6199356
100-4023065356222,210607848
100-4023065360221,2183745
100-4023065604200,610036460
100-4023065850210,634275

 

lbendlin , can you pls try this data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi lbendlin , I have fixed the sample data, can you try with new one, and my main point in the dax query is I want to find total sales based on id,product and during calculation there is if condition and it should provide different topn strategy according to product_id.

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      I still don't understand the business logic.  What are you trying to achieve?

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    well I have got performance issue and I have checked that article as well, but when i change it to addcolumns it is returning different value, so I want to optimize the query.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Doesn't this make more sense?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        I have tried but it didnt return same value, do you think why?