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
Icon for Super User rankSuper 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
    Icon for Super User rankSuper 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.

       

       

       

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

        Hi Anonymous 

        Does the below output meet your requirement?  I've shown the total by fruit in a separate calculated column for an easier visualization of the steps taken, instead of doing all in one step which is more abstruct.  I then wrote a simple if formula to separate out "<=15" and the "rest".  

        I attach an example pbix file. 

        Best regards,