Summary with measures

[Syndicate_Admin]

Hello everyone, make a measure (Total calculation), which is the product of TOTALCONTACTS * %, however in the summary table the sum is wrong, it should be 59.5 but yields 81.

Someone who can help me please

[Ashish_Mathur]

Hi,

Assuming Total Contracts and % are measures that you have writtem try this measure

Measure = SUMX ( 'Table', [TOTALCONTACTS] * [%] )

Hope this helps. 

[v-zhangti · Accepted solution]

Hi, @Syndicate_Admin 

You can try the following methods.

Total = 
IF (HASONEVALUE ( 'Table'[CODIGOESP] ),
    [TOTALCONTACTS] * [%],
    SUMX ( 'Table', [TOTALCONTACTS] * [%] )
)

Is this the result you expect?
Solved: wrong total of measure - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

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

[chris88]

The TOTALCONTACTS (81) is multiplying by the total percent which will be 100%. So the result will always be 81.

I don't have a solution for you but there is a big discussion here you might get some use from:
Dealing with Measure Totals - Microsoft Power BI Community