Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
HenryJS
Post Prodigy
Post Prodigy

Measure Multiply Calculation

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?

 

Capture.PNG

4 REPLIES 4
v-xiaotang
Community Support
Community Support

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
Super User
Super User

@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])

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

 

Capture.PNG

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.