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,

     

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi Anonymous ,

What about writing a table formula like below to produce your required output?  

I attach an example pbix file.  

Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    DataNinja777 ,

     

    Seems I am getting this error now 

    Am I doing something wrong?

    • DataNinja777's avatar
      DataNinja777
      Super User
      2 years ago

      Hi Anonymous 

      That formula is table function so please click "New Table" as shown in the yellow highlighted circle below:

      Best regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        DataNinja777 ,

         

        It is working fine (picture below), but I have one last concern 😊.

         

        Isn't there any way of "grouping" the data inside my initial table? Because I have many other related necessary data inside there that I need to link & use to create filters/legends. The SUMMARIZE table you've just shown me is being created separately from my data.