Adding a custom total Row and Total Column for matrix

[Anonymous]

Hi All,

I am getting wrong column and row totals when I appply filter where growth % over last year is greater than 0. Below is th totalsales dax which I have used. I have also applied filter to not show blank values.

TotalSales = IF(Growth% over LastYear >0, sum(Table[sales]),blank().

[v-danhe-msft]

Hi @Anonymous ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He