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
Anonymous
Not applicable

Dax measure

So I've used this dax measure to find the weighted average for the profit margin which was fine however, after a while it changed and added 0.3 on but the data in excel is all the same. I cant seem to figure out why this has happened. If anyone knows please let me know thanks.

Weighted Average Profit Margin =
DIVIDE ( [IEA*PROFIT MARGIN], SUM ( 'Detail'[IEA] ) )
3 REPLIES 3
V-pazhen-msft
Community Support
Community Support

@Anonymous 

Please share a sample table, it is hard to say without see the table. And also share the dax for the iea profit margin..

 

Thank you

Paul

Fowmy
Super User
Super User

@Anonymous 

The information provided is not sufficient to understand the exact problem. If you can share some sample/dummy data and the expected result, then a solution can be suggested.


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

So my data changed from 0.47 to 0.50 which is inaccurate. But there was no changes made to the data set 

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.