Forum Discussion
Total is wrong
Hello, I have calculated measure Total_LC as given below Total_LC = VAR F12 = SUM('NCC Chart''s'[F12]) VAR H12 = SUM('NCC Chart''s'[H12]) RETURN (average('NCC Chart''s'[Net_NCC_Cost])+ ...
Hi Anonymous,
When you make a measure and add it to a table the measure is calculated in all row including the total, so you need to add a summarization formula in order to have the correct calculation on your total.
Add the following measure and put it on your table:
Total_LC_Row =
IF (
HASONEVALUE ( Table[Project_Number] );
[Total_LC];
SUMX ( Table; [Total_LC] )
)
What this formula does is to check if you have a single value in project number if yes it then does the Total_LC calculation if you don't have a single value in project_number as it happen in total then it does the SUM row by row of each project and returns that total.
You can read more about the SUMX in the following link
Regards,
MFelix
Hello, I tried using your formula but my grand total is still the same