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
aleuer
Frequent Visitor

Calculated Measure Incorrect Total (mulitiplication)

HellO!

 

I'm having some issues with multiplying multiple filtered/calculated measures and yielding a correct result. I get an answer near to what i want, but it's not exact. I am hoping that someone more experienced in the inner workings of Power BI and DAX and lend a hand. 

 

Here are the measures that I have currently, where Cost@January Rate = Jan 2017 Rate * Weighted Words for 2017 for September

 

The result in the table is $49,158.608 NOT $49,089,821 which is the correct result when done in Excel or on a calculator. I'm not sure if this has to do with my measures themselves which are simply filtered column data, or something I'm not considering int he data relationships themselves. 

Any and all help would be appreciated! 

Thanks!

 

 

2017-10-18_1809.png

 

1 ACCEPTED SOLUTION

This worked! 

 

I put the decimals all the way out  then used the ROUND function in DAX to modify my measures. Thanks!

 

I do have the issue now of a (0.00) sum in both Table and Matrix view, which i thought was down to needing a SUMX function, when i do that

Sumx Savings = SUMX(RevenueRecognition,[Savings Summary] - it yields an entirely incorrect total. 

My calculation "Savings Summary" ( is correct in the month view, but give me a 0.00 total --> Savings Summary is where i need the sum to be correct 

 

 

 

2017-10-23_1623.png

 

Any help here? 

Thanks in advance!

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

 

There are more decimals in the 0.121 - please check.  49158.608/405701 is 0.1211695509.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

This worked! 

 

I put the decimals all the way out  then used the ROUND function in DAX to modify my measures. Thanks!

 

I do have the issue now of a (0.00) sum in both Table and Matrix view, which i thought was down to needing a SUMX function, when i do that

Sumx Savings = SUMX(RevenueRecognition,[Savings Summary] - it yields an entirely incorrect total. 

My calculation "Savings Summary" ( is correct in the month view, but give me a 0.00 total --> Savings Summary is where i need the sum to be correct 

 

 

 

2017-10-23_1623.png

 

Any help here? 

Thanks in advance!

Hi @aleuer,

 

If my previous reply helped, please mark it as Answer.  Also, share the link from where i can download your file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-huizhn-msft
Employee
Employee

Hi @aleuer,

It's really hard to check the reason without your sample table. You should share the sample table, measure, relationship or .pbix file for further analysis? Hoe do you do in excel? So that we can share detailed solution which is close to you.

Best Regards,
Angelia

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.