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... 303,669 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Giorgio Bonacorsi 617

#2

André Arnaud de Cal... 461 Super User 2026 Season 1

#3

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans