Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Grand total on matrix not calculated correctly

Hello All,   The grand total of my matrix is incorrect:     This is my dax for the revenue:  Revenue = if(CONTAINS('Gp Cons P&L','Gp Cons P&L'[Item No],"4510003"),[CM Act]-[PYM],if...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Does this work?

=IF(HASONEVALUE([Item No]),[Revenue],SUMX(SUMMARIZE(VALUES([Item No]),[Item No],"ABCD",[Revenue]),[ABCD]))