Wrong column total in matrix table with months

[Anonymous]

Dear all,

i have this problem in a matrix table in which i have in colums the difference between months from December '19 to September '20.

The problem is that the totals for columns is wrong, in fact my goal is to have a "Total" on columns calculate as a sum from December to September for which rows. I can't add another measure because it will put the measure in each colums so in each months.

The measure used for difference between months is:

MoM = IF(ISBLANK('02 Carte_Mensile'[Stock Carte]),BLANK(),'02 Carte_Mensile'[Stock Carte]-'02 Carte_Mensile'[Previouse month])

The matrix is the following:

Appreciate  help

Thank you all,

Lorenzo

[Anonymous]

Hi  @Anonymous ,

According to your description, I created some data to show:

Here are the steps you can follow：

1. Create a measure to filter. The original total after filtering is 3500, but the display is 4900

Measure = IF(SUM('Table'[Amount])<1000,0,SUM('Table'[Amount]))

2. Create a measure for total.

Total =
var _new=SUMMARIZE('Table','Table'[Amount],"_value",[Measure])

return IF(HASONEVALUE('Table'[Amount]),[Measure],SUMX(_new,[_value]))

3. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try something like

MoM = sumx(values(Table[Account]),IF(ISBLANK('02 Carte_Mensile'[Stock Carte]),BLANK(),'02 Carte_Mensile'[Stock Carte]-'02 Carte_Mensile'[Previouse month]) )

[Anonymous]

Thank you,

i have already tried with this kind of Dax but unfortunately it doesn't work here.