Forum Discussion
Solved
Summary with measures
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...
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 CommunityBest 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.
Hi,
Assuming Total Contracts and % are measures that you have writtem try this measure
Measure = SUMX ( 'Table', [TOTALCONTACTS] * [%] )Hope this helps.