Sum if movement

[FrancisGhao]

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 grand total is showing all projects. 

Can you please provide pointers how to resolve it?

Here is the file.

[TomasAndersson]

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!

[TomasAndersson · Accepted solution]

You can read an article about it here: Summing values for the total - SQLBI

[FrancisGhao]

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]

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 😅