- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Divide function not showing correct result
Hi community,
I'm trying to use the divide function but it's not showing the correct results for me. The formula looks like this:
Omloopsnelheid = DIVIDE(SUM(GRV_StockpositionsPerDay[Stock]);SUM('100_Voorraadmutaties'[Eruit positief]);0)
The GRV_StockPositionsPerDay[Stock] is the 'Voorraadstand' in the first picture. The 100_Voorraadmutaties[Eruit positief] is the Eruit posititief in the second picture. So what I want is 65.401,00 / 700.348,00 = 0,09338... But it's giving me 0,00290.
Anyone who knows how to tackle this problem? Thanks in advance!
Kind regards,
Dexter
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it seems that the two table is not properly related.
Look to whats append if you bring the "Eruit positief" column in the first table.
If you don't solve post the pbix, i'll try to take a look.
GP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it seems that the two table is not properly related.
Look to whats append if you bring the "Eruit positief" column in the first table.
If you don't solve post the pbix, i'll try to take a look.
GP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you GP, when you said relation I checked into the relation between the tables and thats fixed it! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If I just divide the columns without using DAX it gives the same answer. Also when I use divide the numerator and denumerator need a function I believe.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-09-2024 08:46 AM | |||
04-18-2024 12:30 AM | |||
Anonymous
| 12-03-2023 09:35 AM | ||
05-25-2024 07:07 PM | |||
Anonymous
| 07-03-2024 02:28 AM |
User | Count |
---|---|
141 | |
115 | |
82 | |
63 | |
48 |