Dividing on condition (DAX)

[Anonymous]

Hey guys,

At first I want to let you know that I'm new to PowerBi.

I want to create a % value based on the data (with dax coding)

The picture you see here is an example of the value that I can simulate in a visual model

pic 1

I want to create that the value "27" will be divided by the value "132" based on the condition that the same number is selected.

For example = (27/132) = 0.20 = 20% 

based on selection the 70X-XXXID value:

Explanation

The tables used for this visual:

pic 2

 

In the visual (pic 1) I have imported the values from multiple columns and I select based on the 70X-XXXID value.

This value comes back in both columns and I already have set up the connection between both tables.

Table 1: OrderTime_lookup

- In the visual (pic 1) I summarized the "tijd min" based on the condition that it matches the selected 70X-XXXID value. The value "132" in the pic 1 is an example of this.

Table 2: Geschatte werktijd

- In this column I have the hours converted to the minutes and "order nummer" is linked to 70X-XXXID

- "geschatte tijd in min" is equal to the number "27" in pic 1 and is just a look up value

It is at this point that the struggling for me begins, because I have no experience with DAX coding.

I have to divide the summarized values of "tijd min" by the value in "geschatte tijd in min" based on the 70X-XXXID.

I thought that this formula would work in DAX, but it didn't work 😞

Measure = DIVIDE(ALLSELECTED(OrderTime_Lookup[tijd min]), ALLSELECTED(Effectiviteitsgraad[geschatte tijd in min]))

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Please try this measure:

Percentage = DIVIDE(SUM('Ordertime lookup'[tijd min]),SUM('geschatte tijd'[geschatte tijd in min]))

You need to use SUM function to calculate the sum total of the values before you use them in the DIVIDE function. 

Then you can change the measure's format to Percentage by Measure tools -> Formatting.

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

[vanessafvg]

can you provide data in text format?

[Anonymous]

I don't really know if this is what you mean (need).

Ordertime lookup

id slaveId datStart datEnd color Tijd totaal tijd min 70X-XXXID Post Nieuwe Order min Voorbeiden min Assembleren min Controleren min Rework min Reparatie / Loopactie min
488 10 16:33:46 16:56:29 80FF00 0,015775463 23 704-462-Q63 Assembleren 23
335 12 13:45:02 14:07:29 80FF00 0,015590278 23 704-462-Q03 Assembleren 23
337 12 14:10:44 14:34:39 80FF00 0,016608796 24 704-462-Q03 Assembleren 24
340 12 14:35:28 14:54:28 80FF00 0,013194444 19 704-462-Q03 Assembleren 19
342 12 14:55:35 15:27:35 80FF00 0,022222222 32 704-462-Q03 Assembleren 32
483 10 13:49:06 17:15:34 80FF00 0,14337963 207 704-443 Assembleren 207
418 10 08:00:57 11:10:36 80FF00 0,131701389 190 704-429 Assembleren 190
417 11 16:13:40 16:50:52 80FF00 0,025833333 38 704-424 Assembleren 38
410 11 14:22:20 15:29:52 80FF00 0,046898148 68 704-424 Assembleren 68
419 11 08:00:30 09:10:55 80FF00 0,048900463 71 704-424 Assembleren 71
495 11 15:32:59 16:10:09 80FF00 0,025810185 38 704-424 Assembleren 38
408 10 13:56:42 15:56:05 80FF00 0,082905093 120 704-409 Assembleren 120
402 11 11:05:28 11:33:54 80FF00 0,01974537 29 704-408 Assembleren 29
406 11 11:43:59 13:27:52 80FF00 0,072141204 104 704-408 Assembleren 104
434 12 14:19:16 15:16:03 80FF00 0,03943287 57 704-399 Assembleren 57
443 12 08:02:38 08:14:24 80FF00 0,008171296 12 704-399 Assembleren 12
162 8 08:34:32 10:31:00 80FF00 0,08087963 117 704-397 Assembleren 117
440 9 16:12:39 16:44:20 80FF00 0,022002315 32 704-395 Assembleren 32
420 9 09:27:00 09:42:21 80FF00 0,010659722 16 704-394 Assembleren 16
373 9 09:49:29 10:53:05 80FF00 0,044166667 64 704-391 Assembleren 64
389 9 14:45:56 14:54:02 80FF00 0,005625 9 704-391 Assembleren 9
382 9 11:53:42 14:12:38 80FF00 0,096481481 139 704-391 Assembleren 139
379 9 11:30:48 11:50:34 80FF00 0,013726852 20 704-391 Assembleren 20
378 9 11:01:49 11:23:39 80FF00 0,015162037 22 704-391 Assembleren 22
439 12 15:42:34 16:24:07 80FF00 0,028854167 42 704-391 Assembleren 42
357 9 09:39:03 09:40:17 80FF00 0,000856481 2 704-391 Assembleren 2
437 12 15:21:35 15:32:15 80FF00 0,007407407 11 704-391 Assembleren 11
377 9 10:53:05 11:00:38 80FF00 0,005243056 8 704-391 Assembleren 8
391 9 14:55:29 15:24:26 80FF00 0,020104167 29 704-391 Assembleren 29
474 11 08:42:15 09:58:41 80FF00 0,053078704 77 704-377 Assembleren 77
469 11 08:01:41 08:39:41 80FF00 0,026388889 38 704-377 Assembleren 38
505 11 12:59:59 16:11:41 80FF00 0,133125 192 704-377 Assembleren 192
482 10 15:17:07 16:12:10 80FF00 0,038229167 56 704-377 Assembleren 56
455 11 12:17:34 14:30:41 80FF00 0,09244213 134 704-377 Assembleren 134
472 10 08:04:10 08:34:03 80FF00 0,020752315 30 704-377 Assembleren 30
456 10 11:44:40 12:22:13 80FF00 0,026076389 38 704-377 Assembleren 38
431 11 14:30:12 16:57:54 80FF00 0,102569444 148 704-377 Assembleren 148
498 11 10:14:41 10:15:57 80FF00 0,00087963 2 704-377 Assembleren 2
464 11 15:17:08 16:26:31 80FF00 0,04818287 70 704-377 Assembleren 70
481 10 13:44:04 15:15:18 80FF00 0,063356481 92 704-377 Assembleren 92
444 10 08:17:45 08:31:31 80FF00 0,009560185 14 704-377 Assembleren 14
445 11 07:56:34 08:15:55 80FF00 0,0134375 20 704-377 Assembleren 20
501 11 10:18:03 12:27:52 80FF00 0,090150463 130 704-377 Assembleren 130
446 10 08:33:01 09:28:00 80FF00 0,03818287 55 704-377 Assembleren 55
460 11 14:33:56 15:14:26 80FF00 0,028125 41 704-377 Assembleren 41
447 11 08:55:55 10:36:04 80FF00 0,069548611 101 704-377 Assembleren 101
448 10 09:33:22 10:44:00 80FF00 0,049050926 71 704-377 Assembleren 71
451 11 11:00:58 12:16:40 80FF00 0,052569444 76 704-377 Assembleren 76
457 10 13:01:02 13:41:30 80FF00 0,028101852 41 704-377 Assembleren 41
490 10 08:38:21 09:25:52 80FF00 0,032997685 48 704-377 Assembleren 48
465 9 14:34:46 14:56:30 80FF00 0,015092593 22 704-376 Assembleren 22
458 9 11:56:24 14:09:50 80FF00 0,092662037 134 704-376 Assembleren 134
461 9 14:12:41 14:31:50 80FF00 0,013298611 20 704-376 Assembleren 20
476 9 10:54:46 11:45:46 80FF00 0,035416667 51 704-376 Assembleren 51
468 9 16:11:52 16:39:59 80FF00 0,019525463 29 704-376 Assembleren 29
466 9 15:21:12 16:07:01 80FF00 0,03181713 46 704-376 Assembleren 46
497 8 08:02:46 09:58:58 80FF00 0,080694444 117 704-376 Assembleren 117
471 9 08:03:31 08:16:29 80FF00 0,00900463 13 704-373 Assembleren 13
470 9 08:24:21 08:31:49 80FF00 0,005185185 8 704-372 Assembleren 8
436 9 14:46:50 16:03:20 80FF00 0,053125 77 704-364 Assembleren 77
433 9 12:27:04 14:35:27 80FF00 0,089155093 129 704-363 Assembleren 129
499 9 08:53:16 09:42:59 80FF00 0,034525463 50 704-352 Assembleren 50
423 9 11:13:34 11:42:20 80FF00 0,019976852 29 704-348 Assembleren 29
422 9 10:43:49 11:11:19 80FF00 0,019097222 28 704-348 Assembleren 28
421 9 09:45:40 10:40:20 80FF00 0,037962963 55 704-348 Assembleren 55
427 9 11:45:55 12:16:30 80FF00 0,021238426 31 704-348 Assembleren 31
315 13 08:19:57 08:55:51 80FF00 0,024930556 36 704-340 Assembleren 36
314 13 08:04:05 08:08:52 80FF00 0,003321759 5 704-340 Assembleren 5
308 13 16:05:35 17:04:20 80FF00 0,040798611 59 704-340 Assembleren 59
299 13 14:19:44 14:51:56 80FF00 0,022361111 33 704-339 Assembleren 33
292 13 10:24:59 10:57:36 80FF00 0,022650463 33 704-339 Assembleren 33
284 13 08:50:00 09:14:10 80FF00 0,016782407 25 704-339 Assembleren 25
297 13 13:04:19 13:44:45 80FF00 0,028078704 41 704-339 Assembleren 41
295 13 11:19:44 12:17:12 80FF00 0,039907407 58 704-339 Assembleren 58
303 10 15:36:38 16:31:04 80FF00 0,037800926 55 704-317 Assembleren 55
273 11 11:06:09 12:05:16 80FF00 0,041053241 60 704-317 Assembleren 60
296 10 14:10:02 15:35:07 80FF00 0,059085648 86 704-317 Assembleren 86
267 11 08:59:49 09:40:59 80FF00 0,028587963 42 704-317 Assembleren 42
279 11 16:15:17 16:26:35 80FF00 0,007847222 12 704-317 Assembleren 12
274 10 13:27:06 14:30:27 80FF00 0,043993056 64 704-317 Assembleren 64
275 11 12:10:00 13:38:24 80FF00 0,061388889 89 704-317 Assembleren 89
272 10 12:02:15 13:25:51 80FF00 0,058055556 84 704-317 Assembleren 84
280 10 08:12:40 09:28:20 80FF00 0,052546296 76 704-317 Assembleren 76
311 10 07:59:46 09:00:53 80FF00 0,04244213 62 704-317 Assembleren 62
318 11 08:52:11 09:46:02 80FF00 0,037395833 54 704-317 Assembleren 54
290 10 11:00:27 13:02:14 80FF00 0,084571759 122 704-317 Assembleren 122
265 10 08:17:33 09:14:39 80FF00 0,039652778 58 704-317 Assembleren 58
492 10 14:31:29 15:56:23 80FF00 0,058958333 85 704-317 Assembleren 85
266 11 08:00:06 08:53:45 80FF00 0,037256944 54 704-317 Assembleren 54
327 11 09:48:22 11:07:05 80FF00 0,054664352 79 704-317 Assembleren 79
289 10 10:44:07 10:58:56 80FF00 0,010289352 15 704-317 Assembleren 15
326 10 10:51:42 11:27:56 80FF00 0,025162037 37 704-317 Assembleren 37
316 10 09:01:45 10:20:41 80FF00 0,054814815 79 704-317 Assembleren 79
287 10 10:33:10 10:42:56 80FF00 0,006782407 10 704-317 Assembleren 10
282 10 09:29:37 10:27:44 80FF00 0,040358796 59 704-317 Assembleren 59
264 10 07:59:27 08:16:08 80FF00 0,011585648 17 704-317 Assembleren 17
278 11 14:49:35 16:13:15 80FF00 0,058101852 84 704-317 Assembleren 84
270 10 11:13:09 11:35:35 80FF00 0,015578704 23 704-317 Assembleren 23
313 11 08:01:57 08:49:38 80FF00 0,033113426 48 704-317 Assembleren 48
277 11 13:46:08 14:46:55 80FF00 0,042210648 61 704-317 Assembleren 61
269 11 09:45:29 11:02:18 80FF00 0,053344907 77 704-317 Assembleren 77
293 10 13:04:14 14:04:49 80FF00 0,042071759 61 704-317 Assembleren 61
353 11 08:00:14 08:17:33 80FF00 0,012025463 18 703-971 Assembleren 18
359 10 08:01:48 10:20:11 80FF00 0,096099537 139 703-971 Assembleren 139
345 11 14:41:36 15:25:05 80FF00 0,030196759 44 703-971 Assembleren 44
380 11 12:10:42 13:53:25 80FF00 0,071331019 103 703-971 Assembleren 103
393 10 10:33:54 10:50:57 80FF00 0,011840278 18 703-971 Assembleren 18
347 11 15:26:43 15:32:05 80FF00 0,003726852 6 703-971 Assembleren 6
338 11 13:32:57 14:16:39 80FF00 0,030347222 44 703-971 Assembleren 44
375 10 12:09:20 13:17:36 80FF00 0,047407407 69 703-971 Assembleren 69
364 10 11:00:08 11:46:01 80FF00 0,031863426 46 703-971 Assembleren 46
349 11 15:35:43 16:53:41 80FF00 0,054143519 78 703-971 Assembleren 78
366 11 11:02:26 12:09:13 80FF00 0,046377315 67 703-971 Assembleren 67
395 11 09:34:41 09:42:26 80FF00 0,005381944 8 703-971 Assembleren 8
365 10 11:47:23 12:08:24 80FF00 0,014594907 22 703-971 Assembleren 22
362 11 09:44:05 10:58:34 80FF00 0,051724537 75 703-971 Assembleren 75
354 11 08:20:10 09:32:41 80FF00 0,050358796 73 703-971 Assembleren 73
386 10 13:20:29 14:41:51 80FF00 0,05650463 82 703-791 Assembleren 82
486 10 14:43:46 16:57:31 80FF00 0,092881944 134 703-791 Assembleren 134
167 8 13:11:50 13:16:48 80FF00 0,003449074 5 702-793 Assembleren 5
165 8 11:32:35 13:09:42 80FF00 0,06744213 98 702-793 Assembleren 98
478 9 09:45:20 11:15:50 80FF00 0,062847222 91 702-782 Assembleren 91
477 9 15:27:23 16:27:58 80FF00 0,042071759 61 702-782 Assembleren 61
343 9 11:22:41 15:22:29 80FF00 0,166527778 240 702-782 Assembleren 240
170 8 14:02:51 15:17:06 80FF00 0,0515625 75 702-138 Assembleren 75
172 8 15:19:12 15:28:41 80FF00 0,006585648 10 702-138 Assembleren 10
454 10 11:34:56 11:42:15 80FF00 0,005081019 8 530-562 Assembleren 8
416 9 16:13:21 16:18:05 80FF00 0,003287037 5 530-526 Assembleren 5
413 9 16:06:49 16:12:18 80FF00 0,00380787 6 530-525 Assembleren 6
489 10 13:05:56 13:11:34 80FF00 0,003912037 6 704-462-Q63 Nieuwe Order 6
484 10 15:56:05 16:07:35 80FF00 0,007986111 12 704-429 Nieuwe Order 12
496 11 13:39:36 13:45:29 80FF00 0,004085648 6 704-424 Nieuwe Order 6
485 10 12:27:02 12:57:52 80FF00 0,021412037 31 704-409 Nieuwe Order 31
494 11 09:19:09 09:23:13 80FF00 0,002824074 5 704-377 Nieuwe Order 5
493 11 11:10:14 11:16:04 80FF00 0,004050926 6 704-377 Nieuwe Order 6
329 10 11:44:56 13:05:56 80FF00 0,05625 81 704-317 Nieuwe Order 81
301 13 15:19:05 15:30:25 80FF00 0,00787037 12 704-215 Nieuwe Order 12
487 10 14:41:51 14:43:46 80FF00 0,001331019 2 703-791 Nieuwe Order 2
163 8 10:34:37 10:38:02 80FF00 0,002372685 4 702-793 Nieuwe Order 4
479 9 11:15:50 11:22:38 FF0000 0,004722222 7 702-782 Rework 7
480 9 15:33:03 15:36:53 80FF00 0,002662037 4 702-782 Nieuwe Order 4
168 8 13:19:30 13:22:42 80FF00 0,002222222 4 702-138 Nieuwe Order 4
336 12 14:07:29 14:10:44 FF0000 0,002256944 4 704-462-Q03 Werkstation aanvullen 4
463 11 15:14:26 15:17:08 FF0000 0,001875 3 704-429 Collega helpen 3
414 11 16:10:12 16:11:52 FF0000 0,001157407 2 704-424 verbinders bijgehaald 2
411 11 15:30:41 15:31:23 FF0000 0,000486111 1 704-424 mal zagen 1
403 11 11:33:57 11:42:10 FF0000 0,005706019 9 704-408 meehelpen buizen aanvullen zaagstraat 9
435 12 15:16:06 15:20:59 FF0000 0,003391204 5 704-399 Jeffrey assisteren met de reachttruck 5
438 12 15:32:15 15:42:34 FF0000 0,007164352 11 704-391 inslagdop past niet stalen dop in gedaan 11
387 9 14:31:47 14:39:58 FF0000 0,00568287 9 704-391 checklist aanpassen met de veranderingen 9
390 9 14:54:02 14:55:29 FF0000 0,001006944 2 704-391 boormachine halen 2
381 9 14:18:44 14:22:49 FF0000 0,002835648 5 704-391 jan helpen 5
358 9 09:40:20 09:47:15 FF0000 0,004803241 7 704-391 Assemblage station heeft legen bakken 7
398 10 10:28:51 10:31:47 FF0000 0,002037037 3 704-391 E6 buis op juiste positie plaatsen 3
371 9 11:23:39 11:30:48 FF0000 0,004965278 8 704-391 mis malmaat 8
370 9 11:00:38 11:01:49 FF0000 0,000821759 2 704-391 mis malmaat 2
385 9 14:22:49 14:31:44 FF0000 0,00619213 9 704-391 werktekening klopt niet 9
372 9 11:50:34 11:53:42 FF0000 0,002175926 4 704-391 mis malmaat 4
383 9 14:12:38 14:18:44 FF0000 0,004236111 7 704-391 werktekening klopt niet 7
491 10 09:25:58 09:35:44 FF0000 0,006782407 10 704-377 Loopactie 10
473 11 08:39:41 08:42:15 FF0000 0,001782407 3 704-377 "Stan houd me van het werk ;)" 3
500 11 10:15:57 10:18:03 FF0000 0,001458333 3 704-377 Loopactie Materiaal bijvullen 3
426 11 11:28:04 11:30:13 FF0000 0,001493056 3 704-377 Loopactie 3
450 11 10:36:04 11:00:58 FF0000 0,017291667 25 704-377 Broodjes bestellen 25
459 9 14:31:57 14:33:48 FF0000 0,001284722 2 704-376 Lossen 2
467 9 11:45:46 11:56:24 FF0000 0,007384259 11 704-376 tekening klopt niet 11
322 6 10:37:08 10:40:46 FF0000 0,002523148 4 704-340 inscannen na controle 4
300 13 14:51:56 14:59:30 FF0000 0,00525463 8 704-339 Foute wielen ingetekend 8
294 13 12:17:16 13:04:19 FF0000 0,032673611 48 704-339 Loopactie 48
298 13 13:44:48 14:17:13 FF0000 0,022511574 33 704-339 Loopactie 33
285 13 09:14:13 10:24:59 FF0000 0,049143519 71 704-339 NDW met Bowling Karapun 71
323 6 10:17:12 10:20:11 FF0000 0,002071759 3 704-317 verkeerd geboekt door ander tussen werk 3
288 10 10:42:56 10:44:07 FF0000 0,000821759 2 704-317 Storing zaag 2
325 10 10:49:57 10:51:42 FF0000 0,001215278 2 704-317 Materiaal bijvullen 2
271 10 11:35:35 12:02:15 FF0000 0,018518519 27 704-317 Laden Den Hartog 27
286 10 10:27:44 10:33:10 FF0000 0,003773148 6 704-317 Broodjes bestellen 6
360 10 10:21:57 10:33:37 FF0000 0,008101852 12 703-971 laden en papier klaar zetten en verbinders halen 12
361 10 10:51:00 11:00:08 FF0000 0,006342593 10 703-971 laden en lossen 10
346 11 15:25:55 15:26:22 FF0000 0,0003125 1 703-971 lijmklemmen halen 1
363 10 11:46:01 11:46:28 FF0000 0,0003125 1 703-971 Loopactie 1
384 11 14:10:45 14:27:41 FF0000 0,011759259 17 703-971 buizen verkeerd geplaatst bij 6 structuren 17
404 10 11:44:06 11:49:23 FF0000 0,003668981 6 703-971 Stekkerdoos los bij 3 structuren 6
376 10 13:17:36 13:20:20 FF0000 0,001898148 3 703-971 overleggen met jef 3
166 8 13:09:42 13:11:50 FF0000 0,001481481 3 702-793 Loopactie 3
171 8 15:17:06 15:19:12 FF0000 0,001458333 3 702-138 Loopactie 3
348 12 15:27:35 15:49:45 80FF00 0,015393519 23 704-462-Q03 Controleren 23
399 10 10:31:47 11:00:47 80FF00 0,020138889 29 704-391 Controleren 29
442 12 16:27:21 16:53:16 80FF00 0,017997685 26 704-391 Controleren 26
397 10 10:17:57 10:28:51 80FF00 0,007569444 11 704-391 Controleren 11
321 6 10:21:36 10:34:17 80FF00 0,00880787 13 704-340 Controleren 13
305 6 15:48:45 16:12:14 80FF00 0,01630787 24 704-339 Controleren 24
331 6 11:48:29 11:56:23 80FF00 0,005486111 8 704-317 Controleren 8
40 6 10:26:07 11:02:22 80FF00 0,025173611 37 704-317 Controleren 37
319 6 08:49:04 08:52:34 80FF00 0,002430556 4 704-317 Controleren 4
302 9 14:53:04 15:32:42 80FF00 0,027523148 40 704-252 Controleren 40
405 10 11:49:23 12:27:02 80FF00 0,026145833 38 703-971 Controleren 38
401 10 11:16:48 11:44:06 80FF00 0,018958333 28 703-971 Controleren 28
31 6 09:45:58 10:58:44 80FF00 0,050532407 73 702-894 Controleren 73
33 6 11:39:29 11:57:16 80FF00 0,012349537 18 702-894 Controleren 18
351 6 15:24:11 16:11:46 80FF00 0,033043981 48 702-782 Controleren 48
174 8 15:59:05 16:53:31 80FF00 0,037800926 55 704-481 Voorbereiden 55
173 8 15:54:52 15:59:05 80FF00 0,002928241 5 704-481 Voorbereiden 5
332 10 13:11:34 13:28:27 80FF00 0,011724537 17 704-462-Q63 Voorbereiden 17
334 12 13:29:54 13:45:02 80FF00 0,010509259 16 704-462-Q03 Voorbereiden 16
428 10 13:04:12 13:47:31 80FF00 0,030081019 44 704-443 Voorbereiden 44
415 10 16:07:35 17:15:34 80FF00 0,047210648 68 704-429 Voorbereiden 68
409 11 13:45:33 14:19:52 80FF00 0,023831019 35 704-424 Voorbereiden 35
407 10 12:57:52 13:56:42 80FF00 0,040856481 59 704-409 Voorbereiden 59
396 11 10:15:06 10:38:53 80FF00 0,016516204 24 704-408 Voorbereiden 24
400 11 10:56:36 11:03:52 80FF00 0,005046296 8 704-408 Voorbereiden 8
429 12 13:44:21 14:17:16 80FF00 0,022858796 33 704-399 Voorbereiden 33
161 8 08:22:51 08:33:34 80FF00 0,00744213 11 704-397 Voorbereiden 11
388 9 14:39:58 14:44:14 80FF00 0,002962963 5 704-391 Voorbereiden 5
355 9 08:18:21 09:36:37 80FF00 0,054351852 79 704-391 Voorbereiden 79
430 11 13:13:33 14:30:12 80FF00 0,053229167 77 704-377 Voorbereiden 77
425 11 11:30:13 12:06:34 80FF00 0,025243056 37 704-377 Voorbereiden 37
424 11 11:16:04 11:28:04 80FF00 0,008333333 12 704-377 Voorbereiden 12
432 11 12:06:34 13:13:33 80FF00 0,046516204 67 704-377 Voorbereiden 67
449 9 08:35:54 10:49:46 80FF00 0,092962963 134 704-376 Voorbereiden 134
475 9 08:50:17 08:51:56 80FF00 0,001145833 2 704-352 Voorbereiden 2
309 13 15:41:37 16:05:35 80FF00 0,016643519 24 704-340 Voorbereiden 24
281 13 08:09:34 08:49:28 80FF00 0,027708333 40 704-339 Voorbereiden 40
306 10 16:32:23 16:55:44 80FF00 0,016215278 24 704-317 Voorbereiden 24
394 11 16:23:31 16:41:41 80FF00 0,012615741 19 703-971 Voorbereiden 19
392 11 14:29:50 15:59:41 80FF00 0,062395833 90 703-971 Voorbereiden 90
333 11 11:58:34 13:31:05 80FF00 0,064247685 93 703-971 Voorbereiden 93
164 8 11:15:24 11:32:06 80FF00 0,011597222 17 702-793 Voorbereiden 17
317 9 08:47:19 09:43:59 80FF00 0,039351852 57 702-782 Voorbereiden 57
307 9 16:22:23 17:00:54 80FF00 0,026747685 39 702-782 Voorbereiden 39
169 8 13:22:42 14:02:16 80FF00 0,027476852 40 702-138 Voorbereiden 40
452 10 10:47:07 11:33:25 80FF00 0,032152778 47 530-562 Voorbereiden 47
412 9 15:50:15 16:03:14 80FF00 0,009016204 13 530-525 Voorbereiden 13

geschatte tijd

order nummer geschatte tijd
530-525 00:33:38
530-526 00:33:38
702-138 03:44:45
702-782 04:28:50
702-793 02:04:41
703-971 04:28:59
704-252 01:56:53
704-317 03:43:35
704-339 10:14:57
704-340 03:32:52
704-348 02:49:27
704-363 03:44:31
704-364 04:55:21
704-376 03:01:09
704-377 04:30:47
704-391 08:25:16
704-394 01:54:05
704-395 02:47:43
704-397 02:23:38
704-399 04:59:35
704-408 05:49:56
704-409 05:24:12
704-424 11:48:45
704-429 05:11:51
704-443 03:05:03
704-462-Q03 01:16:40
704-481 01:34:19

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Please try this measure:

Percentage = DIVIDE(SUM('Ordertime lookup'[tijd min]),SUM('geschatte tijd'[geschatte tijd in min]))

You need to use SUM function to calculate the sum total of the values before you use them in the DIVIDE function. 

Then you can change the measure's format to Percentage by Measure tools -> Formatting.

Best Regards,

Community Support Team _ Jing Zhang

If this post helps, please consider Accept it as the solution to help other members find it.

[Anonymous]

@v-jingzhang 

Thank you for your reply,

This is the correct answer, it functions perfect now.

But I still have one question depending on my main message.

Is the starting table crucial to let the code function properly?

Because I also tried your code but at that time it didn't work for me.

I think that reason for this is that I didn't use the correct starting table.

Because when you click for new measure it will link the start table with the first table in fields.

Greetings,

SRMulti 

[v-jingzhang]

@Anonymous 

I'm glad that my reply is helpful to you.

For your question, measures work the same no matter what tables they are created in. So when we use a measure in DAX code, we usually use it as [Measure Name], but when we use columns, we need to use them as 'Table Name'[Column Name] to specify which table a column is from. So I guess my code didn't work probably because the table name or column name I used in my code is not the same as yours so the column couldn't be found in your tables?

Best regards,

Jing

[Anonymous · Accepted solution]

Dear @v-jingzhang 

in each case I didn't have any problem with it when I added it to my dashboard.

Now that you have the sample data maybe you can also help me with a question I'm currently dealing with.

I'm trying to show the average % value of the previous calculation.

But to my understanding you can't look at a measurement, because it's not specified as a column. 

So i thought maybe I can show the average value with the following code

I thought maybe by dividing the unique row count of the table I would get the average value.

But my Excel sheets shows another value:

Do you know a solution for this (or how I need to modify the dax code)?

Greetings,

SRMulti

[Anonymous]

I just realised that if I don't click an 70X-XXXID value it will show me the average value.

So consider this question as if I didn't ask it.

[Anonymous]

I don't really understand what you need?

Do you need the raw data in text format (how do I share this)?