web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Measure using divide c...

Finance | Project Operations, Human Resources, ...

Unanswered

Measure using divide calculates incorrectly

(0) Share

Report

Report

Posted on by acehays

2

I have a very simple measure but the results are wrong, for instance;

So the .03% should be 6%

The No_ field is a document number so I am counting that and sum of Deal Reg is a calculated column =if([Deal Reg No_]<>BLANK(),1) so I am summing it

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dan,

Which exact Dynamics product are you using? You only shared small parts of your screens. I'm not able to directly link this to Dynamics AX where you posted your question. Please provide more information so we know what you are trying to achieve and where you source your data.

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
It looks like you're using Power BI or a similar data analysis tool. In order to get better help, it is recommended that you provide a complete screenshot of the information or a text description. Judging from your screenshot information, you can check the data and data type in the "Deal Reg No_" column. Verify that you are using the correct aggregation method in your report or visualization. If you are summing the "Deal Reg" column, it should be a sum, not a count.
Best Regards,
Hana

Was this reply helpful? Yes No
acehays 2 on at

Like (0)

Report

Ahh so sorry I am on the wrong forum, newbie and lack of attention. But to assuage your curiosity it is Excel PowerPivot Pro data model and trying to show in a pivot. I tend to test things there before I use PowerBI. Yes I was summing Deal Reg No, but the denominator is text so I am counting.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 592 Most Valuable Professional

#2

André Arnaud de Cal... 478 Super User 2025 Season 2

#3

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans