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

 

Can you please provide pointers how to resolve it?

Here is the file.

Need Help

4 Replies

  • TomasAndersson's avatar
    TomasAndersson
    Solution 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.