Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dividing on condition (DAX)

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]))

Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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's avatar
    Anonymous
    5 years ago

    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

     

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I don't really understand what you need?

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        5 years ago

        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.