Forum Discussion
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...
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])
Thanks amitchandak see link to access sample data https://drive.google.com/drive/folders/1o-w5BZBVZCHkfNboDbWg5soJBsnXENTO?usp=sharing
Please note, I just want to recreate Column 3, but only display the positive value of 199.85. I am hoping this will also display as the total.
Thank you so much for the help!
Did you find an answer to this? Having the same problem.
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.