{"id":39,"date":"2026-10-10T10:25:23","date_gmt":"2026-10-10T01:25:23","guid":{"rendered":"https:\/\/vera-b.com\/?p=39"},"modified":"2026-10-10T10:25:23","modified_gmt":"2026-10-10T01:25:23","slug":"dax-divide-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-0%ec%9c%bc%eb%a1%9c-%eb%82%98%eb%88%84%ea%b8%b0-%ec%98%a4%eb%a5%98-%ec%97%86%ec%9d%b4-%eb%b9%84%ec%9c%a8-%ea%b3%84%ec%82%b0%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=39","title":{"rendered":"DAX DIVIDE \ud568\uc218 \uc815\ub9ac: 0\uc73c\ub85c \ub098\ub204\uae30 \uc624\ub958 \uc5c6\uc774 \ube44\uc728 \uacc4\uc0b0\ud558\uae30"},"content":{"rendered":"\n

\ub2ec\uc131\ub960, \uc804\ud658\uc728, \ub9c8\uc9c4\uc728\ucc98\ub7fc \ubcf4\uace0\uc11c\uc5d0\ub294 \ube44\uc728\uc774 \uc815\ub9d0 \ub9ce\uc774 \ub098\uc635\ub2c8\ub2e4. \ube44\uc728\uc740 \ub098\ub217\uc148\uc774\uace0, \ub098\ub217\uc148\uc5d0\ub294 \ub298 \uac19\uc740 \ubb38\uc81c\uac00 \ub530\ub77c\uc635\ub2c8\ub2e4. \ubd84\ubaa8\uac00 0\uc774\uac70\ub098 \ube44\uc5b4 \uc788\uc73c\uba74 \uc5b4\ub5bb\uac8c \ud558\ub290\ub0d0\ub294 \uac83\uc785\ub2c8\ub2e4. \uc55e\uc120 \uae00\ub4e4\uc5d0\uc11c \ube44\uc728\uc744 \uad6c\ud560 \ub54c\ub9c8\ub2e4 \uc2ac\uca4d \uc0ac\uc6a9\ud588\ub358 DIVIDE\uac00 \ubc14\ub85c \uc774 \ubb38\uc81c\ub97c \ub2e4\ub8e8\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 DIVIDE\uc758 \ubb38\ubc95\uacfc \ub3d9\uc791, \ub098\ub204\uae30 \uc5f0\uc0b0\uc790(\/)\uc640 \ubb34\uc5c7\uc774 \ub2e4\ub978\uc9c0, \uadf8\ub9ac\uace0 \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \ub9cc\ub098\ub294 \uc138 \uac00\uc9c0 \uc0c1\ud669(\ub2ec\uc131\ub960, \uc804\ud658\uc728, \ud569\uacc4 \uc904\uc758 \ube44\uc728)\uc744 \uac19\uc740 \ub370\uc774\ud130\ub85c \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n

\ubb38\ubc95<\/h2>\n\n
DIVIDE( <\ubd84\uc790>, <\ubd84\ubaa8> [, <\ub300\uccb4\uac12>] )<\/code><\/pre>\n\n
Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub300\ub85c DIVIDE\ub294 \ub098\ub217\uc148\uc744 \ud558\uace0, 0\uc73c\ub85c \ub098\ub204\ub294 \uacbd\uc6b0\uc5d0\ub294 \ub300\uccb4\uac12\uc774\ub098 \ube48 \uac12(BLANK)\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4. \uc138 \ubc88\uc9f8 \uc778\uc218\uc778 \ub300\uccb4\uac12\uc740 \uc0dd\ub7b5\ud560 \uc218 \uc788\uace0, \uc0dd\ub7b5\ud558\uba74 \uae30\ubcf8\uac12\uc774 BLANK\uc785\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \uc18c\uc218 \ud615\ud0dc\uc758 \uc22b\uc790\uc785\ub2c8\ub2e4. \ubb38\uc11c\uac00 \ub4dc\ub294 \uc608\ub294 \uc138 \uac00\uc9c0\uc785\ub2c8\ub2e4. DIVIDE(5, 2)<\/code>\ub294 2.5, DIVIDE(5, 0)<\/code>\uc740 \ube48 \uac12, DIVIDE(5, 0, 1)<\/code>\uc740 1\uc785\ub2c8\ub2e4.<\/p>\n\n
\ud55c \uac00\uc9c0 \uc81c\uc57d\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ub300\uccb4\uac12\uc740 \uc0c1\uc218\uc5ec\uc57c \ud569\ub2c8\ub2e4<\/strong>. \ub2e4\ub978 \uce21\uc815\uac12\uc774\ub098 \uacc4\uc0b0\uc2dd\uc744 \ub300\uccb4\uac12 \uc790\ub9ac\uc5d0 \ub123\uc744 \uc218 \uc5c6\ub2e4\uace0 Microsoft \ubb38\uc11c\uac00 \uba85\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n\n
Power BI Desktop\uc5d0\uc11c \uce21\uc815\uac12\uc73c\ub85c \ub9cc\ub4e4\uae30<\/h2>\n\n
\uba54\ub274 \uc774\ub984\uc740 Power BI \ubc84\uc804\uacfc \uc5b8\uc5b4 \uc124\uc815\uc5d0 \ub530\ub77c \uc870\uae08 \ub2e4\ub97c \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \uba3c\uc800 \ub9d0\uc500\ub4dc\ub9bd\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc778 \uc21c\uc11c\ub294 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \n
  1. \ubcf4\uace0\uc11c \ubcf4\uae30\uc5d0\uc11c \uc624\ub978\ucabd \ud544\ub4dc \ucc3d\uc758 \ud14c\uc774\ube14(\uc608: \uc9c0\uc5ed\uc131\uacfc)\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n
  2. \uc0c1\ub2e8 \ub9ac\ubcf8\uc5d0\uc11c “\uc0c8 \uce21\uc815\uac12”(\uc601\ubb38\ud310\uc740 New measure)\uc744 \ub204\ub985\ub2c8\ub2e4.<\/li>\n
  3. \uc218\uc2dd \uc785\ub825\uc904\uc5d0 \ub2ec\uc131\ub960 = DIVIDE( [\ucd1d\ub9e4\ucd9c], [\ucd1d\ubaa9\ud45c] )<\/code>\ucc98\ub7fc \uc774\ub984\uacfc \uc2dd\uc744 \uc801\uace0 Enter\ub97c \ub204\ub985\ub2c8\ub2e4.<\/li>\n
  4. \ub9cc\ub4e0 \uce21\uc815\uac12\uc744 \ud45c \uc2dc\uac01\ud654\uc5d0 \uc62c\ub9ac\uace0, \uc11c\uc2dd\uc744 \ubc31\ubd84\uc728\ub85c \ubc14\uafd4 \uc904\ub9c8\ub2e4 \uac12\uc774 \uc5b4\ub5bb\uac8c \ub098\uc624\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
    \uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
    \uc124\uba85\ud558\ub824\uace0 \ub9cc\ub4e0 \uac00\uc0c1 \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \ub300\uad6c\ub294 \ubc29\ubb38\uc790\uac00 0\uba85\uc774\uace0, \uad11\uc8fc\ub294 \ubaa9\ud45c\uac00 \ube44\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\ub294 Power BI\uc5d0\uc11c \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uc9c1\uc811 \uad6c\ud55c \uac12\uc774\ub2c8, \uac19\uc740 \uc2dd\uc744 \ubcf8\uc778 \ub370\uc774\ud130\uc5d0 \uc801\uc6a9\ud574\uc11c \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/p>\n\n\n\n
    \uc9c0\uc5ed<\/th>\ub9e4\ucd9c<\/th>\ubaa9\ud45c<\/th>\ubc29\ubb38\uc790<\/th>\uad6c\ub9e4\uc790<\/th><\/tr><\/thead>\n
    \uc11c\uc6b8<\/td>300<\/td>250<\/td>100<\/td>20<\/td><\/tr>\n
    \ubd80\uc0b0<\/td>120<\/td>200<\/td>80<\/td>8<\/td><\/tr>\n
    \ub300\uad6c<\/td>0<\/td>100<\/td>0<\/td>0<\/td><\/tr>\n
    \uad11\uc8fc<\/td>50<\/td>(\ube48 \uac12)<\/td>40<\/td>4<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ucd1d\ub9e4\ucd9c = SUM( \uc9c0\uc5ed\uc131\uacfc[\ub9e4\ucd9c] )\n\ucd1d\ubaa9\ud45c = SUM( \uc9c0\uc5ed\uc131\uacfc[\ubaa9\ud45c] )\n\ucd1d\ubc29\ubb38\uc790 = SUM( \uc9c0\uc5ed\uc131\uacfc[\ubc29\ubb38\uc790] )\n\ucd1d\uad6c\ub9e4\uc790 = SUM( \uc9c0\uc5ed\uc131\uacfc[\uad6c\ub9e4\uc790] )<\/code><\/pre>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \ubaa9\ud45c \ub2ec\uc131\ub960<\/h2>\n\n
    \ub2ec\uc131\ub960 = DIVIDE( [\ucd1d\ub9e4\ucd9c], [\ucd1d\ubaa9\ud45c] )<\/code><\/pre>\n\n\n\n
    \uc9c0\uc5ed<\/th>\ucd1d\ub9e4\ucd9c<\/th>\ucd1d\ubaa9\ud45c<\/th>\ub2ec\uc131\ub960<\/th><\/tr><\/thead>\n
    \uc11c\uc6b8<\/td>300<\/td>250<\/td>120%<\/td><\/tr>\n
    \ubd80\uc0b0<\/td>120<\/td>200<\/td>60%<\/td><\/tr>\n
    \ub300\uad6c<\/td>0<\/td>100<\/td>0%<\/td><\/tr>\n
    \uad11\uc8fc<\/td>50<\/td>(\ube48 \uac12)<\/td>(\ube48 \uac12)<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc11c\uc6b8\uc740 300 \u00f7 250 = 120%, \ubd80\uc0b0\uc740 120 \u00f7 200 = 60%\uc785\ub2c8\ub2e4. \ub300\uad6c\ub294 \ub9e4\ucd9c\uc774 0\uc774\uace0 \ubaa9\ud45c\uac00 100\uc774\ub2c8 0 \u00f7 100 = 0%\ub85c \uacc4\uc0b0\ub429\ub2c8\ub2e4. \ubd84\uc790\uac00 0\uc778 \uac83\uc740 \ubb38\uc81c\uac00 \uc544\ub2c8\uace0, \ubd84\ubaa8\uac00 0\uc77c \ub54c\ub9cc DIVIDE\uc758 \ud2b9\ubcc4\ud55c \ucc98\ub9ac\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uad11\uc8fc\ub294 \ubaa9\ud45c\uac00 \ube44\uc5b4 \uc788\uc5b4\uc11c, \ubd84\ubaa8\uac00 \ube48 \uac12\uc774\ub77c \uacb0\uacfc\ub3c4 \ube48 \uac12\uc785\ub2c8\ub2e4. SQLBI\ub294 \ub300\uccb4\uac12\uc744 \uc8fc\uc9c0 \uc54a\uc558\uc744 \ub54c \ubd84\ubaa8\uac00 0\uc774\uac70\ub098 \ube48 \uac12\uc774\uba74 DIVIDE\uac00 \ube48 \uac12\uc744 \ub3cc\ub824\uc900\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. “\ubaa9\ud45c\uac00 \uc5c6\ub294 \uc9c0\uc5ed\uc758 \ub2ec\uc131\ub960”\uc740 \uc22b\uc790\ub85c \ud45c\ud604\ud560 \uc218 \uc5c6\uc73c\ub2c8 \ube48 \uac12\uc73c\ub85c \ub450\ub294 \uac83\uc774 \ub300\uac1c\ub294 \uc790\uc5f0\uc2a4\ub7fd\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \uc804\ud658\uc728\uacfc 0\/0<\/h2>\n\n
    \uc804\ud658\uc728 = DIVIDE( [\ucd1d\uad6c\ub9e4\uc790], [\ucd1d\ubc29\ubb38\uc790] )<\/code><\/pre>\n\n\n\n
    \uc9c0\uc5ed<\/th>\ucd1d\ubc29\ubb38\uc790<\/th>\ucd1d\uad6c\ub9e4\uc790<\/th>\uc804\ud658\uc728<\/th><\/tr><\/thead>\n
    \uc11c\uc6b8<\/td>100<\/td>20<\/td>20%<\/td><\/tr>\n
    \ubd80\uc0b0<\/td>80<\/td>8<\/td>10%<\/td><\/tr>\n
    \ub300\uad6c<\/td>0<\/td>0<\/td>(\ube48 \uac12)<\/td><\/tr>\n
    \uad11\uc8fc<\/td>40<\/td>4<\/td>10%<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ub300\uad6c\ub294 \ubc29\ubb38\uc790\ub3c4 0\uba85\uc774\uace0 \uad6c\ub9e4\uc790\ub3c4 0\uba85\uc774\ub77c 0 \u00f7 0\uc774 \ub429\ub2c8\ub2e4. \ub098\ub204\uae30 \uc5f0\uc0b0\uc790(\/)\ub85c \uc774 \uc2dd\uc744 \uc4f0\uba74 \ubb38\uc81c\uac00 \uc0dd\uae41\ub2c8\ub2e4. DAX Guide\uc640 SQLBI\ub294 \uc5f0\uc0b0\uc790\uac00 0\uc73c\ub85c \ub098\ub204\uba74 \uc624\ub958\uac00 \uc544\ub2c8\ub77c \ubd84\uc790\uc758 \ubd80\ud638\uc5d0 \ub530\ub77c \uc591\uc758 \ubb34\ud55c\ub300\ub098 \uc74c\uc758 \ubb34\ud55c\ub300\ub97c, 0 \u00f7 0\uc740 NaN(\uc22b\uc790\uac00 \uc544\ub2d8)\uc744 \ub3cc\ub824\uc900\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc5d0 “Infinity”, “NaN” \uac19\uc740 \uae00\uc790\uac00 \uadf8\ub300\ub85c \ub098\ud0c0\ub098\ub294 \uc77c\uc774 \uc0dd\uae30\ub294 \uac83\uc774\uc8e0. DIVIDE\ub97c \uc4f0\uba74 \uadf8 \uc790\ub9ac\uac00 \uae54\ub054\ud558\uac8c \ube48 \uac12\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n
    \ube48 \uac12 \ub300\uc2e0 0%\ub85c \ubcf4\uc5ec\uc8fc\uace0 \uc2f6\ub2e4\uba74 \uc138 \ubc88\uc9f8 \uc778\uc218\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n
    \uc804\ud658\uc728_0\ud45c\uc2dc = DIVIDE( [\ucd1d\uad6c\ub9e4\uc790], [\ucd1d\ubc29\ubb38\uc790], 0 )<\/code><\/pre>\n\n
    \uc774\ub807\uac8c \ud558\uba74 \ub300\uad6c\uac00 0%\ub85c \ub098\uc635\ub2c8\ub2e4. \ub2e4\ub9cc “\ubc29\ubb38\uc790\uac00 \uc544\uc608 \uc5c6\ub294 \uc9c0\uc5ed”\uc744 0%\ub85c \ubcf4\uc5ec\uc8fc\ub294 \uac83\uc774 \ub9de\ub294\uc9c0\ub294 \uc0dd\uac01\ud574 \ubd10\uc57c \ud569\ub2c8\ub2e4. \ubc29\ubb38\uc790\uac00 \uc5c6\uc5b4\uc11c \uc804\ud658\uc728\uc744 \uad6c\ud560 \uc218 \uc5c6\ub294 \uac83\uacfc \ubc29\ubb38\uc790\uac00 \uc788\uc5c8\ub294\ub370 \uc544\ubb34\ub3c4 \uc0ac\uc9c0 \uc54a\uc544 0%\uc778 \uac83\uc740 \ub2e4\ub978 \uc0c1\ud669\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. SQLBI\ub294 \ube48 \uac12 \ub300\uc2e0 0\uc744 \ubcf4\uc5ec\uc904 \ub54c \ub370\uc774\ud130\uac00 \uc5c6\ub294 \ud56d\ubaa9\uae4c\uc9c0 \uc904\uc774 \ub298\uc5b4\ub098\ub294 \ubd80\uc791\uc6a9\uc774 \uc788\ub2e4\uace0 \uc124\uba85\ud558\uae30\ub3c4 \ud569\ub2c8\ub2e4. \uc9c8\ubb38\uc758 \uc131\uaca9\uc5d0 \ub530\ub77c \uc815\ud558\uc138\uc694.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \ud569\uacc4 \uc904\uc758 \ube44\uc728<\/h2>\n\n
    \ud569\uacc4 \uc904\uc740 \uac01 \uc904\uc758 \uac12\uc744 \ud3c9\uade0\ud55c \uac83\uc774 \uc544\ub2c8\ub77c, \ud544\ud130 \uc5c6\uc774 \ubd84\uc790\uc640 \ubd84\ubaa8\ub97c \uac01\uac01 \ud569\ud55c \ub4a4 \ub098\ub208 \uac12\uc785\ub2c8\ub2e4. \uc55e\uc120 AVERAGE \ud568\uc218 \uae00<\/a>\uc5d0\uc11c \ubcf8 “\ud569\uacc4 \uc904\uc740 \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \uacc4\uc0b0\ud55c \uac12”\uc774\ub77c\ub294 \uc6d0\ub9ac\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc774 \uc608\uc81c\uc5d0\uc11c \ud569\uacc4\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uad6c\ubd84<\/th>\ucd1d\ub9e4\ucd9c<\/th>\ucd1d\ubaa9\ud45c<\/th>\ub2ec\uc131\ub960<\/th>\ucd1d\ubc29\ubb38\uc790<\/th>\ucd1d\uad6c\ub9e4\uc790<\/th>\uc804\ud658\uc728<\/th><\/tr><\/thead>\n
    \ud569\uacc4<\/td>470<\/td>550<\/td>85.5%<\/td>220<\/td>32<\/td>14.5%<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ucd1d\ub9e4\ucd9c\uc740 300 + 120 + 0 + 50 = 470\uc774\uace0, \ucd1d\ubaa9\ud45c\ub294 250 + 200 + 100 = 550\uc785\ub2c8\ub2e4(\uad11\uc8fc\uc758 \ube48 \uac12\uc740 \ud569\uacc4\uc5d0\uc11c \uac74\ub108\ub701\ub2c8\ub2e4). \ub2ec\uc131\ub960\uc740 470 \u00f7 550 = \uc57d 85.5%<\/strong>\uc785\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \uc5ec\uae30\uc5d0\ub294 \ud568\uc815\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uad11\uc8fc\ub294 \ubaa9\ud45c\uac00 \uc5c6\ub294\ub370 \ub9e4\ucd9c 50\uc740 \ubd84\uc790\uc5d0 \ub4e4\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ubaa9\ud45c\uac00 \uc788\ub294 \uc9c0\uc5ed\ub07c\ub9ac\ub9cc \ube44\uad50\ud558\uba74 (300 + 120 + 0) \u00f7 550 = \uc57d 76.4%<\/strong>\uc785\ub2c8\ub2e4. \ud569\uacc4 \uc904\uc758 85.5%\ub294 \uad11\uc8fc\uc758 \ub9e4\ucd9c\uc774 \ub2ec\uc131\ub960\uc744 \ubd80\ud480\ub9b0 \uac12\uc785\ub2c8\ub2e4. \ubd84\uc790\uc640 \ubd84\ubaa8\uac00 \uac19\uc740 \ub300\uc0c1\uc744 \uac00\ub9ac\ud0a4\ub294\uc9c0 \ud655\uc778\ud558\ub294 \uac83\uc740 DIVIDE\uac00 \ud574 \uc8fc\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc804\ud658\uc728\uc758 \ud569\uacc4\ub294 \uad6c\ub9e4\uc790 32 \u00f7 \ubc29\ubb38\uc790 220 = \uc57d 14.5%<\/strong>\uc785\ub2c8\ub2e4. \uc904\ubcc4 \uc804\ud658\uc728(20%, 10%, \ube48 \uac12, 10%)\uc744 \ud3c9\uade0\ud55c \uac12(\uc57d 13.3%)\uacfc \ub2e4\ub985\ub2c8\ub2e4. \ubc29\ubb38\uc790\uac00 \ub9ce\uc740 \uc11c\uc6b8\uc758 \ube44\uc911\uc774 \ub354 \ud06c\uac8c \ubc18\uc601\ub418\uae30 \ub54c\ubb38\uc774\uace0, \ubcf4\ud1b5\uc740 \ud569\uacc4 \uc904 \uac12\uc774 \uc2e4\uc81c \uc804\uccb4 \uc804\ud658\uc728\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4.<\/p>\n\n
    DIVIDE\uc640 \ub098\ub204\uae30 \uc5f0\uc0b0\uc790(\/), \ubb34\uc5c7\uc744 \uc4f8\uae4c<\/h2>\n\n\n\n
    \uc0c1\ud669<\/th>\uc4f8 \ubc29\ubc95<\/th><\/tr><\/thead>\n
    \ubd84\ubaa8\uac00 \uce21\uc815\uac12\uc774\ub098 \uc5f4\uc774\ub77c 0\uc774\ub098 \ube48 \uac12\uc774 \ub098\uc62c \uc218 \uc788\ub2e4<\/td>DIVIDE<\/td><\/tr>\n
    \ubd84\ubaa8\uac00 \uc0c1\uc218\ub2e4 (\uc608: \ucc9c \ub2e8\uc704\ub85c \ubcc0\ud658\ud558\ub824\uace0 1000\uc73c\ub85c \ub098\ub214)<\/td>\uc5f0\uc0b0\uc790 \/<\/td><\/tr>\n
    0\uc77c \ub54c \ube48 \uac12 \ub300\uc2e0 \ud2b9\uc815 \uac12\uc774 \ud544\uc694\ud558\ub2e4<\/td>DIVIDE( …, …, \uc0c1\uc218 )<\/td><\/tr>\n
    \ubd84\ubaa8\uac00 \uc808\ub300 0\uc774 \ub420 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc54c\uace0 \uc788\ub2e4<\/td>\uc5f0\uc0b0\uc790 \/\ub3c4 \uac00\ub2a5<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    SQLBI\ub294 \ubd84\ubaa8\uac00 0\uc774\ub098 \ube48 \uac12\uc774 \ub420 \uc218 \uc788\ub294 \uc2dd\uc5d0\ub294 DIVIDE\ub97c \uc4f0\uace0, \ubd84\ubaa8\uac00 \uc0c1\uc218\ub77c\uba74 \uc5f0\uc0b0\uc790\ub97c \uc4f0\ub77c\uace0 \uad8c\ud569\ub2c8\ub2e4. \uc131\ub2a5 \uba74\uc5d0\uc11c\ub294 \ub450 \uac00\uc9c0\uac00 \ud568\uaed8 \uc5b8\uae09\ub429\ub2c8\ub2e4. DIVIDE\ub294 \ubd84\ubaa8\uac00 0\uc778\uc9c0 IF\ub85c \uac80\uc0ac\ud558\ub294 \uac83\ubcf4\ub2e4 \ube60\ub974\uac8c \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\uc9c0\ub9cc, \ud56d\uc0c1 \uc218\uc2dd \uc5d4\uc9c4(formula engine)\uc5d0\uc11c \uc2e4\ud589\ub418\uae30 \ub54c\ubb38\uc5d0 \ub2e8\uc21c\ud55c \ub098\ub204\uae30 \uc5f0\uc0b0\uc790\ubcf4\ub2e4\ub294 \ub290\ub9b4 \uc218 \uc788\ub2e4\uace0 DAX Guide\uac00 \uc124\uba85\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub2c8 “\ubb34\uc870\uac74 DIVIDE”\uac00 \uc544\ub2c8\ub77c “0\uc774 \ub098\uc62c \uc218 \uc788\ub294 \ubd84\ubaa8\uc5d0\ub9cc DIVIDE”\ub85c \uae30\uc5b5\ud574 \ub450\uba74 \ub429\ub2c8\ub2e4. Microsoft \ubb38\uc11c\ub3c4 DIVIDE\uc640 \uc5f0\uc0b0\uc790\uc758 \uc120\ud0dd \uae30\uc900\uc744 \ub530\ub85c \ub2e4\ub8ec \ubaa8\ubc94 \uc0ac\ub840 \ubb38\uc11c\ub97c \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/p>\n\n
    IF\ub85c \uc9c1\uc811 \uac80\uc0ac\ud558\uba74 \uc774\ub807\uac8c \uae38\uc5b4\uc9d1\ub2c8\ub2e4<\/h2>\n\n
    DIVIDE\uac00 \uc5c6\ub358 \uc2dc\uc808\uc758 \ubc29\uc2dd\uc774\uc790 \uc9c0\uae08\ub3c4 \uc885\uc885 \ubcf4\uc774\ub294 \uc2dd\uc740 \ubd84\ubaa8\ub97c \uc9c1\uc811 \uac80\uc0ac\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n
    \uc804\ud658\uc728_IF =\nIF(\n    [\ucd1d\ubc29\ubb38\uc790] = 0 || ISBLANK( [\ucd1d\ubc29\ubb38\uc790] ),\n    BLANK(),\n    [\ucd1d\uad6c\ub9e4\uc790] \/ [\ucd1d\ubc29\ubb38\uc790]\n)<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 DIVIDE( [\ucd1d\uad6c\ub9e4\uc790], [\ucd1d\ubc29\ubb38\uc790] )\uc640 \uac19\uc9c0\ub9cc \uc2dd\uc774 \uae38\uace0 \ubd84\ubaa8 \uce21\uc815\uac12\uc744 \ub450\uc138 \ubc88 \uacc4\uc0b0\ud558\uac8c \ub429\ub2c8\ub2e4. \uc55e\uc11c \uc18c\uac1c\ud55c \uac83\ucc98\ub7fc DAX Guide\uc640 SQLBI\ub294 DIVIDE\uac00 \uc774\ub7f0 IF \uac80\uc0ac\ubcf4\ub2e4 \ube60\ub974\uac8c \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\ub2e4\uace0 \uc124\uba85\ud558\ub2c8, \ud2b9\ubcc4\ud55c \uc774\uc720\uac00 \uc5c6\ub2e4\uba74 DIVIDE\ub85c \ubc14\uafb8\ub294 \ud3b8\uc774 \uc77d\uae30\uc5d0\ub3c4 \ub0ab\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc4f0\uc9c0 \ub9d0\uc544\uc57c \ud560 \ub54c<\/h2>\n\n
      \n
    • \ubd84\ubaa8\uac00 \uc0c1\uc218\uc77c \ub54c<\/strong>: \ubd88\ud544\uc694\ud558\uac8c \uc218\uc2dd \uc5d4\uc9c4\uc744 \uac70\uce58\uac8c \ud558\uc9c0 \ub9d0\uace0 \uc5f0\uc0b0\uc790\ub97c \uc4f0\uc138\uc694.<\/li>\n
    • \ub300\uccb4\uac12 \uc790\ub9ac\uc5d0 \uce21\uc815\uac12\uc774\ub098 \uc2dd\uc744 \ub123\uace0 \uc2f6\uc744 \ub54c<\/strong>: \uc0c1\uc218\ub9cc \uac00\ub2a5\ud569\ub2c8\ub2e4. \ud544\uc694\ud558\uba74 IF \uac19\uc740 \ub2e4\ub978 \ubc29\uc2dd\uc73c\ub85c \ud480\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
    • \uc815\uc218 \ub098\ub217\uc148\uc758 \ubaab\uc774 \ud544\uc694\ud560 \ub54c<\/strong>: \ubaab\ub9cc \uad6c\ud558\ub294 \ud568\uc218(QUOTIENT)\uac00 \ub530\ub85c \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
      \uc54c\uc544\ub458 \uc810<\/h2>\n\n
        \n
      • \ub300\uccb4\uac12\uc740 \uc0c1\uc218\uc5ec\uc57c \ud569\ub2c8\ub2e4. \uc0dd\ub7b5\ud558\uba74 BLANK\uc785\ub2c8\ub2e4.<\/li>\n
      • \ubd84\ubaa8\uac00 \ube48 \uac12\uc77c \ub54c\ub3c4 \ub300\uccb4\uac12\uc744 \uc8fc\uc9c0 \uc54a\uc73c\uba74 \ube48 \uac12\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li>\n
      • DAX Guide\ub294 DIVIDE\uac00 DirectQuery\uc758 \uce21\uc815\uac12\uacfc \uacc4\uc0b0 \uc5f4\uc5d0\uc11c \uc9c0\uc6d0\ub41c\ub2e4\uace0 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n
      • \uacb0\uacfc\ub294 \uc18c\uc218\ub77c\uc11c \ubcf4\uace0\uc11c\uc5d0\uc11c\ub294 \ubc31\ubd84\uc728 \uc11c\uc2dd\uc744 \ub530\ub85c \uc801\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
      • \uc9c0\uc5ed \uc124\uc815\uc5d0 \ub530\ub77c \uc778\uc218 \uad6c\ubd84\uc790\uac00 \uc27c\ud45c \ub300\uc2e0 \uc138\ubbf8\ucf5c\ub860\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc2dd\uc744 \ubd99\uc5ec \ub123\uc5c8\ub294\ub370 \uc624\ub958\uac00 \ub09c\ub2e4\uba74 \uba3c\uc800 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/li>\n<\/ul>\n\n
        \uc790\uc8fc \ud558\ub294 \uc2e4\uc218<\/h2>\n\n
          \n
        1. \ubd84\ubaa8\uac00 \ube48 \uac12\uc774\uac70\ub098 0\uc77c \ub54c \uc624\ub958\ub97c \ub9c9\uc73c\ub824\uace0 IF\ub85c \uac10\uc308<\/strong>: DIVIDE\uac00 \ub354 \uac04\uacb0\ud558\uace0 \ube60\ub974\uac8c \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
        2. 0\uc77c \ub54c 0\uc744 \ubcf4\uc5ec\uc8fc\ub824\uace0 \ubb34\uc870\uac74 \uc138 \ubc88\uc9f8 \uc778\uc218\uc5d0 0\uc744 \ub123\uc74c<\/strong>: “\uacc4\uc0b0\ud560 \uc218 \uc5c6\uc74c”\uacfc “\uc2e4\uc81c\ub85c 0″\uc774 \uc11e\uc785\ub2c8\ub2e4.<\/li>\n
        3. \ud569\uacc4 \uc904\uc758 \ube44\uc728\uc744 \uc904\ubcc4 \ube44\uc728\uc758 \ud3c9\uade0\uc73c\ub85c \uc774\ud574<\/strong>: \ud569\uacc4 \uc904\uc740 \ubd84\uc790\uc640 \ubd84\ubaa8\ub97c \uac01\uac01 \ud569\ud55c \ub4a4 \ub098\ub208 \uac12\uc785\ub2c8\ub2e4.<\/li>\n
        4. \ubd84\uc790\uc640 \ubd84\ubaa8\uc758 \uae30\uc900\uc774 \ub2e4\ub984<\/strong>: \uad11\uc8fc \uc608\uc2dc\ucc98\ub7fc \ud55c\ucabd\uc5d0\ub9cc \uac12\uc774 \uc788\uc73c\uba74 \ube44\uc728\uc774 \uc65c\uace1\ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
          \ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n
            \n
          • QUOTIENT<\/strong>: \ub098\ub217\uc148\uc758 \uc815\uc218 \ubaab\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4.<\/li>\n
          • IFERROR<\/strong>: \uc624\ub958\uac00 \ub098\uba74 \uc9c0\uc815\ud55c \uac12\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4. DIVIDE\uc640 \ub2ec\ub9ac \ubaa8\ub4e0 \uc885\ub958\uc758 \uc624\ub958\ub97c \uac00\ub9bd\ub2c8\ub2e4.<\/li>\n
          • IF<\/strong>: \ubd84\ubaa8\ub97c \uc9c1\uc811 \uac80\uc0ac\ud558\ub294 \ubc29\uc2dd. DIVIDE\ubcf4\ub2e4 \uae38\uace0 \ub290\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
            \uc815\ub9ac<\/h2>\n\n
            DIVIDE\ub294 “\ub098\ub204\ub418, \ubd84\ubaa8\uac00 0\uc774\uac70\ub098 \ube44\uc5b4 \uc788\uc73c\uba74 \uc548\uc804\ud558\uac8c \ucc98\ub9ac\ud55c\ub2e4”\ub294 \ud55c \ubb38\uc7a5\uc73c\ub85c \uc694\uc57d\ub429\ub2c8\ub2e4. \ubd84\ubaa8\uac00 0\uc774\ub098 \ube48 \uac12\uc774 \ub420 \uc218 \uc788\ub2e4\uba74 DIVIDE\ub97c, \uc0c1\uc218\ub85c \ub098\ub208\ub2e4\uba74 \uc5f0\uc0b0\uc790\ub97c \uc4f0\uace0, \ud569\uacc4 \uc904\uc758 \ube44\uc728\uc740 \ubd84\uc790\uc640 \ubd84\ubaa8\ub97c \uac01\uac01 \ud569\ud55c \ub4a4 \ub098\ub208 \uac12\uc774\ub77c\ub294 \uc810, \uadf8\ub9ac\uace0 \ubd84\uc790\uc640 \ubd84\ubaa8\uac00 \uac19\uc740 \ub300\uc0c1\uc744 \uac00\ub9ac\ud0a4\ub294\uc9c0\ub294 \uc2a4\uc2a4\ub85c \ud655\uc778\ud574\uc57c \ud55c\ub2e4\ub294 \uc810\uc744 \uae30\uc5b5\ud574 \ub450\uc138\uc694. \uc608\uc81c\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc774\ub2c8 \ubcf8\uc778 \ubaa8\ub378\uc758 \uc5f4 \uc774\ub984\uc73c\ub85c \ubc14\uafd4 \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc2dc\uace0, \ub3d9\uc791\uc740 \ubc84\uc804\uc5d0 \ub530\ub77c \ub2e4\ub97c \uc218 \uc788\uc5b4 \uacf5\uc2dd \ubb38\uc11c\ub3c4 \ud568\uaed8 \ubcf4\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4.<\/p>\n\n
            \ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n
              \n
            • Microsoft Learn, DIVIDE function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/divide-function-dax<\/li>\n
            • Microsoft Learn, DIVIDE function vs. divide operator (\/) in DAX: https:\/\/learn.microsoft.com\/en-us\/dax\/best-practices\/dax-divide-function-operator<\/li>\n
            • DAX Guide, DIVIDE: https:\/\/dax.guide\/divide\/<\/li>\n
            • SQLBI, DIVIDE vs division operator in DAX: https:\/\/www.sqlbi.com\/blog\/marco\/2014\/07\/24\/divide-vs-division-operator-in-dax\/<\/li>\n
            • SQLBI, DIVIDE Performance: https:\/\/www.sqlbi.com\/articles\/divide-performance\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
              DAX DIVIDE \ud568\uc218\uc758 \ubb38\ubc95\uacfc \ub300\uccb4\uac12, \ub098\ub204\uae30 \uc5f0\uc0b0\uc790(\/)\uc640\uc758 \ucc28\uc774, \ub2ec\uc131\ub960\u00b7\uc804\ud658\uc728\u00b7\ud569\uacc4 \uc904 \ube44\uc728 \uc2dc\ub098\ub9ac\uc624\ub97c \uac00\uc0c1 \ub370\uc774\ud130 \uc608\uc81c\ub85c \uc815\ub9ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[4,19,6],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-divide","tag-power-bi"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/39","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions"}],"predecessor-version":[{"id":47,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions\/47"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}