Forum Discussion

mwen90's avatar
mwen90
Icon for Helper III rankHelper III
4 years ago

If statement not totalling in matrix

Hi,    I have a scenario where I am trying to calculate Column A - Column B. However, some of my Column A items are 0, so the solution is negative Column B value.    Where this happens, I want to...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mwen90 , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Make sure this is the new column

Column 2=  if([Column3]<0, blank(), [Column3])

    • Sirhawk3017's avatar
      Sirhawk3017
      Icon for Helper II rankHelper II
      2 years ago

      Did you find an answer to this? Having the same problem.

      • mwen90's avatar
        mwen90
        Icon for Helper III rankHelper III
        2 years ago

        Yeah, I used Sumx(Summarize(......). I then input my table and the columns which were in the matrix. 

         

        You need to play around with the order of the summarize.

  • mwen90's avatar
    mwen90
    Icon for Helper III rankHelper III
    4 years ago

    amitchandak  further, if I do the formula you suggested, the coloum 3 value isn't the same?

     

    It's 199.85 in Column 3 , Column 4 is 240?

     

    Cheers,