Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

IF SUM dax issue

Hi,   Can someone help me with this situation I am confronting with?   Based on the raw data on the left, I need to reach to the result on the right, but IF(SUM) is not evaluating correctly. What...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Anonymous ,

    I think you already have your own answer.  

    You can create the matrix like above from what you already have.  

    Best regards,

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DataNinja777 ,

 

Sorry if I was not very clear.

 

Does this new sample explain what I am trying to achieve? 😊

I just need the same formula that you've shared with me (SUMMARIZE) to work inside my original datasource directly, so I can play with the rest of the columns (Color, Size, etc)

 

 

 

 

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

I think you already have your own answer.  

You can create the matrix like above from what you already have.  

Best regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    DataNinja777 ,

     

    Many thanks🎉! This one involving EARLIER is the right one. Sorry, I might have missed something, but I've tried it out again and it works perfectly!

     

    Regards