Measure Multiply Calculation

[HenryJS]

Hi all,

The below 'mult' measure seems to be calculating incorrectly.

325 x 149 = 48,425

the measure returns 48,409? what is causing this error?

[v-xiaotang]

Hi @HenryJS 

Have you solved this problem? If solved, can you share your solution so that others have same problem can refer to it? If not, can you provide more details?

Best Regards,

Community Support Team _ Tang

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

[amitchandak]

@HenryJS , Multiplication should be done at line level. If not use values or summarize to get correct total

Sumx(Values(Table[Date]), [Multi Meaure])

or

sumx(summarize(Table, Table[Date], Table[Other grouping of visual] , "_1",[Multi Meaure]), [_1])

[HenryJS]

@amitchandak  unfortunately this just returned the same result. see below

[amitchandak]

@HenryJS , If possible, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.