Forum Discussion
Wrong table total
Hello! I reach out to you in hopes to get help here. I have tables where the total does not sum up the correct way. See example: The red area to the left= The companies in our busi...
Hi Anonymous ,
I suggest you to use SUMX() function to create a new measure based on [Average lönekostnad ex soc].
New Average lönekostnad ex soc = SUMX ( VALUES ( 'TableName'[ColumnName on Matrix Row] ), [Average lönekostnad ex soc] )Total lönekostnad ex. soc = [New Average lönekostnad ex soc] * [Antal konsulter]Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I suggest you to use SUMX() function to create a new measure based on [Average lönekostnad ex soc].
New Average lönekostnad ex soc =
SUMX (
VALUES ( 'TableName'[ColumnName on Matrix Row] ),
[Average lönekostnad ex soc]
)Total lönekostnad ex. soc =
[New Average lönekostnad ex soc] * [Antal konsulter]
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.