Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sum if movement

Hi All, In a periodic report, I only want to show the projects that has movement in the selected month.  I was using blank function to hide the projects without movement (column 04 & 06), but the g...
Need Help
TomasAndersson's avatar
TomasAndersson
Icon for Solution Sage rankSolution Sage
3 years ago

Hi,
Great that you attached a sample file!

Power BI totals matrixes in a non-intuitive way. Many times, using SUMX() can fix it. I made a small tweak to your measure, wrapping everything in a SUMX(), to get the following:

Hope this helps!

 



    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you and appreciated for the article! New Dax user here and it feels so different from excel. Result code is not always visualized so it is a steeper learning curve.

      • TomasAndersson's avatar
        TomasAndersson
        Icon for Solution Sage rankSolution Sage
        3 years ago

        Yeah haha. I'm came to Power BI from Excel as well. The first hour or so was easy doing a few SUM() and AVERAGE()-s, but as soon as you come to just a bit more complicated stuff you have to start to think in an entirely new way ğŸ˜…