{"id":40,"date":"2026-10-11T08:39:12","date_gmt":"2026-10-10T23:39:12","guid":{"rendered":"https:\/\/vera-b.com\/?p=40"},"modified":"2026-10-11T08:39:12","modified_gmt":"2026-10-10T23:39:12","slug":"dax-if-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ec%a1%b0%ea%b1%b4-%eb%b6%84%ea%b8%b0-%ec%83%9d%eb%9e%b5%ed%95%9c-else%ec%99%80-%ed%95%a9%ea%b3%84-%ec%a4%84%ec%9d%98-%ed%95%a8%ec%a0%95","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=40","title":{"rendered":"DAX IF \ud568\uc218 \uc815\ub9ac: \uc870\uac74 \ubd84\uae30, \uc0dd\ub7b5\ud55c else\uc640 \ud569\uacc4 \uc904\uc758 \ud568\uc815"},"content":{"rendered":"\n<p>\uc870\uac74\uc5d0 \ub530\ub77c \ub2e4\ub978 \uac12\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc2f6\uc744 \ub54c \uac00\uc7a5 \uba3c\uc800 \ub5a0\uc624\ub974\ub294 \ud568\uc218\uac00 IF\uc785\ub2c8\ub2e4. \uc5d1\uc140\uc758 IF\uc640 \ubaa8\uc591\uc774 \uac70\uc758 \uac19\uc544\uc11c \uae08\ubc29 \uc4f0\uac8c \ub418\ub294\ub370, DAX\uc5d0\uc11c\ub294 \uba87 \uac00\uc9c0\uac00 \uc870\uae08 \ub2e4\ub974\uac8c \ub3d9\uc791\ud569\ub2c8\ub2e4. else\ub97c \uc0dd\ub7b5\ud558\uba74 \ube48 \uac12\uc774 \ub098\uc628\ub2e4\ub294 \uc810, \ub450 \uacb0\uacfc\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc774 \ub2e4\ub974\uba74 \uc5b4\ub5bb\uac8c \ub418\ub294\uc9c0, \ud569\uacc4 \uc904\uc5d0\uc11c \uc870\uac74\uc774 \uc5b4\ub5bb\uac8c \ud3c9\uac00\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \ubd84\uae30 \uc548\uc5d0\uc11c \uc2dd\uc774 \uc5b8\uc81c \uacc4\uc0b0\ub418\ub294\uc9c0\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 IF\uc758 \uae30\ubcf8 \ubb38\ubc95\uacfc \ud568\uaed8 \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \uc4f0\ub294 \uc138 \uac00\uc9c0 \uc0c1\ud669(\uacc4\uc0b0 \uc5f4\uc758 \ub4f1\uae09 \ub098\ub204\uae30, \uc870\uac74\ubd80 \uce21\uc815\uac12, \ud569\uacc4 \uc904\uc758 \ud568\uc815)\uc744 \uac19\uc740 \ub370\uc774\ud130\ub85c \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n<h2>\ubb38\ubc95<\/h2>\n\n<pre><code>IF( &lt;\uc870\uac74&gt;, &lt;\ucc38\uc77c \ub54c \uac12&gt; [, &lt;\uac70\uc9d3\uc77c \ub54c \uac12&gt;] )<\/code><\/pre>\n\n<p>Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub300\ub85c IF\ub294 \uc870\uac74\uc744 \ud655\uc778\ud574\uc11c, \ucc38\uc774\uba74 \ub450 \ubc88\uc9f8 \uc778\uc218\ub97c, \uc544\ub2c8\uba74 \uc138 \ubc88\uc9f8 \uc778\uc218\ub97c \ub3cc\ub824\uc90d\ub2c8\ub2e4. <strong>\uc138 \ubc88\uc9f8 \uc778\uc218\ub294 \uc0dd\ub7b5\ud560 \uc218 \uc788\uace0, \uc0dd\ub7b5\ud558\uba74 \ube48 \uac12(BLANK)\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/strong> \ubc18\ud658\uac12\uc740 \ucc38\uc77c \ub54c \uac12, \uac70\uc9d3\uc77c \ub54c \uac12, \ub610\ub294 \ube48 \uac12 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4.<\/p>\n\n<h2>Power BI Desktop\uc5d0\uc11c \uc4f0\ub294 \ub450 \uac00\uc9c0 \ubc29\ubc95<\/h2>\n\n<p>\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. IF\ub294 \ub450 \uacf3\uc5d0\uc11c \uc790\uc8fc \uc501\ub2c8\ub2e4.<\/p>\n\n<ul>\n<li><strong>\uce21\uc815\uac12<\/strong>: \ub9ac\ubcf8\uc758 &#8220;\uc0c8 \uce21\uc815\uac12&#8221;(\uc601\ubb38\ud310\uc740 New measure)\uc744 \ub20c\ub7ec \uc218\uc2dd \uc785\ub825\uc904\uc5d0 \uc2dd\uc744 \uc801\uc2b5\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc758 \uac01 \uc140\uc774 \uac00\uc9c4 \ud544\ud130 \uc0c1\ud0dc\uc5d0 \ub9de\ucdb0 \ub2e4\uc2dc \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/li>\n<li><strong>\uacc4\uc0b0 \uc5f4<\/strong>: \ud14c\uc774\ube14\uc744 \uc120\ud0dd\ud558\uace0 &#8220;\uc0c8 \uc5f4&#8221;(\uc601\ubb38\ud310\uc740 New column)\uc744 \ub20c\ub7ec \uc2dd\uc744 \uc801\uc2b5\ub2c8\ub2e4. \ud589\ub9c8\ub2e4 \uac12\uc774 \uacc4\uc0b0\ub418\uc5b4 \ubaa8\ub378\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n<h2>\uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n<p>\uc55e\uc120 <a href=\"https:\/\/vera-b.com\/?p=23\">SUMX \ud568\uc218 \uae00<\/a>\uc758 \ub370\uc774\ud130\uc640 \uc774\uc5b4\uc9c0\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \uae08\uc561\uc740 \uc218\ub7c9 \u00d7 \ub2e8\uac00\ub97c \ubbf8\ub9ac \uacc4\uc0b0\ud574 \ub454 \uac12\uc785\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<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc8fc\ubb38<\/th><th>\uc0c1\ud488<\/th><th>\uae08\uc561<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>1<\/td><td>\ub178\ud2b8\ubd81<\/td><td>120<\/td><\/tr>\n<tr><td>2<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>12<\/td><\/tr>\n<tr><td>3<\/td><td>\ubaa8\ub2c8\ud130<\/td><td>40<\/td><\/tr>\n<tr><td>4<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>20<\/td><\/tr>\n<tr><td>5<\/td><td>\ub178\ud2b8\ubd81<\/td><td>200<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<pre><code>\ucd1d\ub9e4\ucd9c = SUM( \uc8fc\ubb38[\uae08\uc561] )<\/code><\/pre>\n\n<p>\ucd1d\ub9e4\ucd9c\uc740 120 + 12 + 40 + 20 + 200 = 392\uc774\uace0, \uc0c1\ud488\ubcc4\ub85c\ub294 \ub178\ud2b8\ubd81 320, \ub9c8\uc6b0\uc2a4 32, \ubaa8\ub2c8\ud130 40\uc785\ub2c8\ub2e4.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \uacc4\uc0b0 \uc5f4\ub85c \ub4f1\uae09 \ub098\ub204\uae30<\/h2>\n\n<p>\uc8fc\ubb38 \uae08\uc561\uc5d0 \ub530\ub77c &#8220;\ub300\ud615&#8221;, &#8220;\uc911\ud615&#8221;, &#8220;\uc18c\ud615&#8221;\uc73c\ub85c \ub098\ub204\ub294 \uacc4\uc0b0 \uc5f4\uc744 \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc870\uac74\uc774 \ub458\uc774\ub77c IF\ub97c \ud55c \ubc88 \uacb9\uccd0 \uc501\ub2c8\ub2e4.<\/p>\n\n<pre><code>\uc8fc\ubb38\ub4f1\uae09 =\nIF(\n    \uc8fc\ubb38[\uae08\uc561] &gt;= 100,\n    \"\ub300\ud615\",\n    IF( \uc8fc\ubb38[\uae08\uc561] &gt;= 30, \"\uc911\ud615\", \"\uc18c\ud615\" )\n)<\/code><\/pre>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc8fc\ubb38<\/th><th>\uae08\uc561<\/th><th>\uc8fc\ubb38\ub4f1\uae09<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>1<\/td><td>120<\/td><td>\ub300\ud615<\/td><\/tr>\n<tr><td>2<\/td><td>12<\/td><td>\uc18c\ud615<\/td><\/tr>\n<tr><td>3<\/td><td>40<\/td><td>\uc911\ud615<\/td><\/tr>\n<tr><td>4<\/td><td>20<\/td><td>\uc18c\ud615<\/td><\/tr>\n<tr><td>5<\/td><td>200<\/td><td>\ub300\ud615<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\ub300\ud615 2\uac74, \uc911\ud615 1\uac74, \uc18c\ud615 2\uac74\uc785\ub2c8\ub2e4. \uc774 \uad6c\uc870\ub294 Microsoft \ubb38\uc11c\uac00 \ubcf4\uc5ec\uc8fc\ub294 \uac00\uaca9\ub300 \ubd84\ub958 \uc608\uc81c\uc640 \uac19\uc740 \ubaa8\uc591\uc774\uace0, \ubb38\uc11c\ub294 \uc774\ub807\uac8c IF\ub97c \uc5ec\ub7ec \ubc88 \uacb9\uccd0\uc57c \ud560 \ub54c\ub294 SWITCH \ud568\uc218\uac00 \ub354 \uae54\ub054\ud560 \uc218 \uc788\ub2e4\uace0 \uc548\ub0b4\ud569\ub2c8\ub2e4. \uc870\uac74\uc774 \ub298\uc5b4\ub0a0\uc218\ub85d \uad04\ud638\uac00 \uae4a\uc5b4\uc838\uc11c \uc77d\uae30 \uc5b4\ub824\uc6cc\uc9c0\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. SWITCH\ub294 \ubcc4\ub3c4 \uae00\uc5d0\uc11c \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n\n<p>\uc138 \ubc88\uc9f8 \uc778\uc218\ub97c \uc0dd\ub7b5\ud558\uba74 \uc5b4\ub5bb\uac8c \ub418\ub294\uc9c0\ub3c4 \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ub300\ud615\ud45c\uc2dc =\nIF( \uc8fc\ubb38[\uae08\uc561] &gt;= 100, \"\ub300\ud615\" )<\/code><\/pre>\n\n<p>1\ubc88\uacfc 5\ubc88 \uc8fc\ubb38\ub9cc &#8220;\ub300\ud615&#8221;\uc774\uace0, \ub098\uba38\uc9c0 \uc138 \uac74\uc740 \uac70\uc9d3\uc77c \ub54c \uac12\uc774 \uc5c6\uc73c\ubbc0\ub85c \ube48 \uac12\uc774 \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \ube48 \uac12\uc774 \uc758\ub3c4\ud55c \uacb0\uacfc\uc778\uc9c0, &#8220;\ud574\ub2f9 \uc5c6\uc74c&#8221; \uac19\uc740 \uae00\uc790\ub97c \ubcf4\uc5ec\uc918\uc57c \ud558\ub294\uc9c0\ub294 \ubcf4\uace0\uc11c\uc5d0\uc11c \uc5b4\ub5bb\uac8c \ubcf4\uc774\uae38 \uc6d0\ud558\ub294\uc9c0\uc5d0 \ub530\ub77c \uc815\ud558\uc138\uc694.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \uc870\uac74\ubd80 \uce21\uc815\uac12\uacfc \ud569\uacc4 \uc904\uc758 \ud568\uc815<\/h2>\n\n<p>&#8220;\ucd1d\ub9e4\ucd9c\uc774 100 \uc774\uc0c1\uc778 \uc0c1\ud488\ub9cc \ub9e4\ucd9c\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc2f6\ub2e4&#8221;\ub294 \uc694\uccad\uc744 IF\ub85c \ud480\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ud070\uc0c1\ud488\ub9e4\ucd9c =\nIF( [\ucd1d\ub9e4\ucd9c] &gt;= 100, [\ucd1d\ub9e4\ucd9c] )<\/code><\/pre>\n\n<p>\uc138 \ubc88\uc9f8 \uc778\uc218\ub97c \uc0dd\ub7b5\ud588\uc73c\ub2c8 \uc870\uac74\uc774 \uac70\uc9d3\uc774\uba74 \ube48 \uac12\uc785\ub2c8\ub2e4. \uc0c1\ud488\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc774\ub807\uac8c \ub098\uc635\ub2c8\ub2e4.<\/p>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc0c1\ud488<\/th><th>\ucd1d\ub9e4\ucd9c<\/th><th>\ud070\uc0c1\ud488\ub9e4\ucd9c<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\ub178\ud2b8\ubd81<\/td><td>320<\/td><td>320<\/td><\/tr>\n<tr><td>\ub9c8\uc6b0\uc2a4<\/td><td>32<\/td><td>(\ube48 \uac12)<\/td><\/tr>\n<tr><td>\ubaa8\ub2c8\ud130<\/td><td>40<\/td><td>(\ube48 \uac12)<\/td><\/tr>\n<tr><td>\ud569\uacc4<\/td><td>392<\/td><td>392<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\ub178\ud2b8\ubd81 320\ub9cc \ubcf4\uc774\ub294\ub370 \ud569\uacc4 \uc904\uc740 320\uc774 \uc544\ub2c8\ub77c <strong>392<\/strong>\uc785\ub2c8\ub2e4. \uc624\ub958\uac00 \uc544\ub2d9\ub2c8\ub2e4. \uce21\uc815\uac12\uc740 \uc904\ub9c8\ub2e4 \ub530\ub85c \uacc4\uc0b0\ub418\ub294\ub370, \ud569\uacc4 \uc904\uc740 \ud544\ud130 \uc5c6\uc774 \uc804\uccb4\ub97c \ub300\uc0c1\uc73c\ub85c \uc0c8\ub85c \uacc4\uc0b0\ud569\ub2c8\ub2e4. \ud569\uacc4 \uc904\uc758 \ucd1d\ub9e4\ucd9c\uc740 392\uc774\uace0 \uc774\uac83\uc740 100 \uc774\uc0c1\uc774\ubbc0\ub85c \uc870\uac74\uc774 \ucc38\uc774 \ub418\uc5b4 392\uac00 \ub098\uc624\ub294 \uac83\uc785\ub2c8\ub2e4. \ud654\uba74\uc5d0 \ubcf4\uc774\ub294 \uc904\uc758 \ud569(320)\uacfc \ub2e4\ub978 \uc774\uc720\uac00 \uc774\uac83\uc785\ub2c8\ub2e4. \uc55e\uc120 <a href=\"https:\/\/vera-b.com\/?p=24\">AVERAGE \ud568\uc218 \uae00<\/a>\uc5d0\uc11c \ubcf8 &#8220;\ud569\uacc4 \uc904\uc740 \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \uacc4\uc0b0\ud55c \uac12&#8221;\uc774\ub77c\ub294 \uc6d0\ub9ac\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n<p>\ud569\uacc4 \uc904\ub3c4 \ubcf4\uc774\ub294 \uc904\uc758 \ud569\uc5d0 \ub9de\ucd94\uace0 \uc2f6\ub2e4\uba74 \uc0c1\ud488 \ubaa9\ub85d \uc704\uc5d0\uc11c \ubc18\ubcf5\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ubc14\uafc9\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ud070\uc0c1\ud488\ub9e4\ucd9c_\ud569\uacc4\uc77c\uce58 =\nSUMX(\n    VALUES( \uc8fc\ubb38[\uc0c1\ud488] ),\n    IF( [\ucd1d\ub9e4\ucd9c] &gt;= 100, [\ucd1d\ub9e4\ucd9c] )\n)<\/code><\/pre>\n\n<p>\uc0c1\ud488 \ubaa9\ub85d(VALUES)\uc744 \ud55c \uc904\uc529 \ub3cc\uba74\uc11c \uac01 \uc0c1\ud488\uc758 \ucd1d\ub9e4\ucd9c\uc774 100 \uc774\uc0c1\uc77c \ub54c\ub9cc \uac12\uc744 \ub0b4\ubcf4\ub0b4\uace0, SUMX\uac00 \uadf8 \uacb0\uacfc\ub97c \ub354\ud569\ub2c8\ub2e4. \uc870\uac74\uc774 \uac70\uc9d3\uc778 \uc0c1\ud488\uc740 \ube48 \uac12\uc774\ub77c \ub354\ud574\uc9c0\uc9c0 \uc54a\uc544\uc11c, \ud569\uacc4 \uc904\ub3c4 \ub178\ud2b8\ubd81\uc758 320 \ud558\ub098\uac00 \ub429\ub2c8\ub2e4. \ubc18\ubcf5 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc744 \ubd80\ub974\uba74 &#8220;\uc9c0\uae08 \ub3c4\ub294 \uc0c1\ud488&#8221;\uc774 \ud544\ud130\ub85c \ubc14\ub00c\ub294 \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4(<a href=\"https:\/\/vera-b.com\/?p=19\">CALCULATE \ud568\uc218 \uae00<\/a> \ucc38\uace0). \uc5b4\ub290 \ucabd\uc774 \ub9de\ub294\uc9c0\ub294 \ubcf4\uace0\uc11c\uac00 \ubcf4\uc5ec\uc8fc\ub824\ub294 \uc22b\uc790\uc5d0 \ub2ec\ub824 \uc788\uc2b5\ub2c8\ub2e4. &#8220;\uc804\uccb4 \ub9e4\ucd9c\uc774 100 \uc774\uc0c1\uc778\uac00&#8221;\ub97c \ubb3b\ub294\ub2e4\uba74 \uc55e\uc758 \uc2dd\uc774, &#8220;\ubcf4\uc774\ub294 \uc904\uc758 \ud569&#8221;\uc744 \uc6d0\ud55c\ub2e4\uba74 \ubc18\ubcf5\ud558\ub294 \uc2dd\uc774 \ub9de\uc2b5\ub2c8\ub2e4.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \ube48 \uac12\uc744 \uac80\uc0ac\ud558\uace0 \ub300\uccb4\ud558\uae30, \uadf8\ub9ac\uace0 \ub370\uc774\ud130 \ud615\uc2dd<\/h2>\n\n<p><a href=\"https:\/\/vera-b.com\/?p=39\">DIVIDE \ud568\uc218 \uae00<\/a>\uc5d0\uc11c \ubcf8 \uac83\ucc98\ub7fc, \ubaa9\ud45c\uac00 \ube44\uc5b4 \uc788\ub294 \uc9c0\uc5ed\uc758 \ub2ec\uc131\ub960\uc740 \ube48 \uac12\uc774 \ub429\ub2c8\ub2e4. \uc774 \ube48 \uce78\uc5d0 &#8220;\ubaa9\ud45c \uc5c6\uc74c&#8221;\uc774\ub77c\ub294 \uae00\uc790\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uc2f6\ub2e4\uba74 \uc774\ub807\uac8c \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ub2ec\uc131\ub960\ud45c\uc2dc =\nIF(\n    ISBLANK( [\ucd1d\ubaa9\ud45c] ),\n    \"\ubaa9\ud45c \uc5c6\uc74c\",\n    DIVIDE( [\ucd1d\ub9e4\ucd9c], [\ucd1d\ubaa9\ud45c] )\n)<\/code><\/pre>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc9c0\uc5ed<\/th><th>\ucd1d\ub9e4\ucd9c<\/th><th>\ucd1d\ubaa9\ud45c<\/th><th>\ub2ec\uc131\ub960\ud45c\uc2dc<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\uc11c\uc6b8<\/td><td>300<\/td><td>250<\/td><td>1.2 (120%)<\/td><\/tr>\n<tr><td>\ubd80\uc0b0<\/td><td>120<\/td><td>200<\/td><td>0.6 (60%)<\/td><\/tr>\n<tr><td>\uad11\uc8fc<\/td><td>50<\/td><td>(\ube48 \uac12)<\/td><td>\ubaa9\ud45c \uc5c6\uc74c<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\uc2dd\uc740 \ub2e8\uc21c\ud55c\ub370 \uc774 \uce21\uc815\uac12\uc5d0\ub294 \uc8fc\uc758\ud560 \uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ucc38\uc77c \ub54c \uac12\uc740 \uae00\uc790(&#8220;\ubaa9\ud45c \uc5c6\uc74c&#8221;)\uc774\uace0 \uac70\uc9d3\uc77c \ub54c \uac12\uc740 \uc22b\uc790\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\ub294 \ub450 \uacb0\uacfc\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc774 \ub2e4\ub974\uba74 IF\uac00 \uc5ec\ub7ec \ud615\uc2dd\uc774 \uc11e\uc778(variant) \uac12\uc744 \ub3cc\ub824\uc904 \uc218 \uc788\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \uc22b\uc790\ub07c\ub9ac\uc77c \ub54c\ub294 \ud558\ub098\uc758 \ud615\uc2dd\uc73c\ub85c \ub9de\ucd94\ub824\uace0 \ud55c\ub2e4\ub294 \uc124\uba85\ub3c4 \uc788\uc5b4\uc11c, \uc608\ub97c \ub4e4\uc5b4 <code>IF( \uc870\uac74, 1.0, 0 )<\/code>\uc740 \uc18c\uc218 \ud615\uc2dd\ub9cc \ub3cc\ub824\uc8fc\uc9c0\ub9cc <code>IF( \uc870\uac74, TRUE(), 0 )<\/code>\uc740 \ucc38\/\uac70\uc9d3\uacfc \uc22b\uc790\uac00 \uc11e\uc5ec \ub098\uc62c \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c \uae00\uc790\uc640 \uc22b\uc790\uac00 \uc11e\uc778 \uce21\uc815\uac12\uc740 \ubc31\ubd84\uc728 \uc11c\uc2dd\uc744 \uc801\uc6a9\ud558\uae30 \uc5b4\ub835\uace0 \uc2dc\uac01\ud654\uc5d0\uc11c \uc815\ub82c\uc774\ub098 \ud569\uacc4\ub3c4 \uace4\ub780\ud574\uc9d1\ub2c8\ub2e4. \uac00\ub2a5\ud558\uba74 \ud55c \uce21\uc815\uac12\uc740 \ud55c \uac00\uc9c0 \ud615\uc2dd\uc73c\ub85c \ub450\uace0, \ube48 \uce78\uc5d0 \uae00\uc790\ub97c \ubcf4\uc5ec\uc8fc\ub294 \uac83\uc740 \uc11c\uc2dd\uc774\ub098 \uc870\uac74\ubd80 \uc11c\uc2dd \ucabd\uc5d0\uc11c \ucc98\ub9ac\ud558\ub294 \uac83\uc744 \uace0\ub824\ud574 \ubcf4\uc138\uc694.<\/p>\n\n<h2>\ubd84\uae30 \uc548\uc5d0\uc11c \uc2dd\uc740 \uc5b8\uc81c \uacc4\uc0b0\ub420\uae4c<\/h2>\n\n<p>DAX Guide\ub294 IF\uac00 \ud544\uc694\ud55c \ubd84\uae30\ub9cc \uacc4\uc0b0\ud558\ub294 \uc9c0\uc5f0 \ud3c9\uac00(lazy evaluation)\ub97c \ud55c\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \uc774 \ucd5c\uc801\ud654\ub97c \ubaa8\ub974\uace0 \uc4f0\uba74 \uc131\ub2a5\uc774 \ub5a8\uc5b4\uc9c0\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. SQLBI\uc758 \uc124\uba85\uc744 \uc694\uc57d\ud558\uba74, \ubcc0\uc218\ub97c IF\ub098 SWITCH <strong>\ubc14\uae65<\/strong>\uc5d0\uc11c \uba3c\uc800 \uc815\uc758\ud558\uba74 \uadf8 \ubcc0\uc218\ub4e4\uc740 \ubd84\uae30\uc640 \uc0c1\uad00\uc5c6\uc774 \ubaa8\ub450 \uacc4\uc0b0\ub429\ub2c8\ub2e4. \ubd84\uae30\uc5d0\uc11c \uc4f8 \uac12\uc740 \uac00\ub2a5\ud558\uba74 \uadf8 <strong>\ubd84\uae30 \uc548<\/strong>\uc5d0\uc11c \ubcc0\uc218\ub85c \uc815\uc758\ud574\uc57c \ud544\uc694\ud55c \uac83\ub9cc \uacc4\uc0b0\ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \ub2e4\ub9cc IF\uc758 \uccab \ubc88\uc9f8 \uc778\uc218(\uc870\uac74)\uc5d0\uc11c \uc4f0\ub294 \ubcc0\uc218\ub294 \ubc14\uae65\uc5d0\uc11c \uc815\uc758\ud574\ub3c4 \uc0c1\uad00\uc5c6\ub2e4\uace0 SQLBI\ub294 \ub367\ubd99\uc785\ub2c8\ub2e4.<\/p>\n\n<pre><code>-- \ub450 \uce21\uc815\uac12\uc744 \ubd84\uae30\uc640 \uc0c1\uad00\uc5c6\uc774 \ud56d\uc0c1 \uacc4\uc0b0\ud558\ub294 \ubc29\uc2dd\n\uacb0\uacfc_\ub098\uc05c\uc608 =\nVAR \ub9e4\ucd9c\uac12 = [\ucd1d\ub9e4\ucd9c]\nVAR \uc6d0\uac00\uac12 = [\ucd1d\uc6d0\uac00]\nRETURN\n    IF( \ub9e4\ucd9c\uac12 &gt;= 100, \ub9e4\ucd9c\uac12 - \uc6d0\uac00\uac12, 0 )\n\n-- \ubd84\uae30 \uc548\uc5d0\uc11c \ud544\uc694\ud560 \ub54c\ub9cc \uacc4\uc0b0\ud558\ub294 \ubc29\uc2dd\n\uacb0\uacfc_\uc88b\uc740\uc608 =\nIF(\n    [\ucd1d\ub9e4\ucd9c] &gt;= 100,\n    VAR \ub9e4\ucd9c\uac12 = [\ucd1d\ub9e4\ucd9c]\n    VAR \uc6d0\uac00\uac12 = [\ucd1d\uc6d0\uac00]\n    RETURN \ub9e4\ucd9c\uac12 - \uc6d0\uac00\uac12,\n    0\n)<\/code><\/pre>\n\n<p>\uc704 \uc608\uc81c\ub294 \uac1c\ub150\uc744 \ubcf4\uc5ec\uc8fc\uae30 \uc704\ud55c \ud615\ud0dc\uc785\ub2c8\ub2e4. \uc774\ub7f0 \ucd5c\uc801\ud654\uac00 \uc2e4\uc81c\ub85c \uc758\ubbf8\uac00 \uc788\ub294\uc9c0\ub294 \ubaa8\ub378 \ud06c\uae30\uc640 \uc2dd\uc758 \ube44\uc6a9\uc5d0 \ub2ec\ub824 \uc788\uace0, \uc131\ub2a5\uc740 DAX Studio \uac19\uc740 \ub3c4\uad6c\ub85c \uce21\uc815\ud574\uc57c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ub300\ub85c \ub450 \ubd84\uae30\ub97c \ud56d\uc0c1 \uacc4\uc0b0\ud558\ub294 \ubc29\uc2dd\uc774 \ub354 \ube60\ub97c \uc218\ub3c4 \uc788\uc5b4\uc11c, \uc774\ub97c \uac15\uc81c\ud558\ub294 \ud568\uc218(IF.EAGER)\uac00 \ub530\ub85c \uc788\uc2b5\ub2c8\ub2e4. DAX Guide\ub294 IF.EAGER\ub97c \ub450 \uacb0\uacfc \uc2dd\uc744 \ud56d\uc0c1 \uacc4\uc0b0\ud558\ub294 \ubc29\uc2dd\uc774\ub77c\uace0 \uc124\uba85\ud558\uba70, \uc2e4\uc81c\ub85c \ube60\ub974\ub2e4\ub294 \uac83\uc744 \uce21\uc815\ud55c \ub4a4\uc5d0\ub9cc \uc4f0\ub77c\uace0 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/p>\n\n<h2>\uc4f0\uc9c0 \ub9d0\uc544\uc57c \ud560 \ub54c<\/h2>\n\n<ul>\n<li><strong>\uc870\uac74\uc774 \uc138 \uac1c \uc774\uc0c1\uc73c\ub85c \uacb9\uce60 \ub54c<\/strong>: IF\ub97c \uae4a\uac8c \uacb9\uce58\uae30\ubcf4\ub2e4 SWITCH\uac00 \uc77d\uae30 \uc27d\uc2b5\ub2c8\ub2e4.<\/li>\n<li><strong>\ubd84\ubaa8\uac00 0\uc77c \uc218 \uc788\ub294 \ub098\ub217\uc148<\/strong>: IF\ub85c \ubd84\ubaa8\ub97c \uc9c1\uc811 \uac80\uc0ac\ud558\uae30\ubcf4\ub2e4 DIVIDE\uac00 \uac04\uacb0\ud558\uace0 \ucd5c\uc801\ud654\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. DAX Guide\ub3c4 IF\uac00 \ube48 \uac12\uc744 \ub3cc\ub824\uc8fc\ub294 \uacbd\uc6b0 DIVIDE\uac00 \ub354 \ube60\ub978 \uacc4\ud68d\uc744 \ub9cc\ub4e4 \uc218 \uc788\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>\ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc918\uc57c \ud560 \ub54c<\/strong>: IF\ub294 \uac12(\uc2a4\uce7c\ub77c)\ub9cc \ub3cc\ub824\uc90d\ub2c8\ub2e4. \ub450 \ubd84\uae30\uac00 \ubaa8\ub450 \ud14c\uc774\ube14\uc744 \ubc18\ud658\ud558\ub294 \uc2dd\uc740 \uc624\ub958\uac00 \ub0a9\ub2c8\ub2e4.<\/li>\n<li><strong>\ud55c \uce21\uc815\uac12\uc5d0 \uae00\uc790\uc640 \uc22b\uc790\ub97c \uc11e\uc5b4\uc57c \ud560 \ub54c<\/strong>: \ud615\uc2dd\uc744 \ud558\ub098\ub85c \ub9de\ucd94\ub294 \ubc29\ubc95\uc744 \uba3c\uc800 \ucc3e\uc544\ubcf4\uc138\uc694.<\/li>\n<\/ul>\n\n<h2>\uc54c\uc544\ub458 \uc810<\/h2>\n\n<ul>\n<li>\uc138 \ubc88\uc9f8 \uc778\uc218\ub97c \uc0dd\ub7b5\ud558\uba74 \ube48 \uac12\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/li>\n<li>\uc5ec\ub7ec IF\ub97c \uacb9\uce58\uba74 \uad04\ud638\uac00 \uae4a\uc5b4\uc9d1\ub2c8\ub2e4. \uad04\ud638\uac00 \ubaa8\ub450 \ub2eb\ud614\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<li>DAX\uc5d0\uc11c \ucc38\/\uac70\uc9d3 \ube44\uad50 \uacb0\uacfc\ub97c \uadf8\ub300\ub85c \uc5f4\ub85c \uc4f8 \uc218\ub3c4 \uc788\uc9c0\ub9cc, \ubcf4\uace0\uc11c\uc5d0\uc11c\ub294 \uae00\uc790(&#8220;\uc608&#8221;, &#8220;\uc544\ub2c8\uc624&#8221;)\ub85c \ubc14\uafd4 \ubcf4\uc5ec\uc8fc\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\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<h2>\uc790\uc8fc \ud558\ub294 \uc2e4\uc218<\/h2>\n\n<ol>\n<li><strong>\ud569\uacc4 \uc904\uc5d0\uc11c \uc870\uac74\uc774 \uc5b4\ub5bb\uac8c \ud3c9\uac00\ub418\ub294\uc9c0 \ubaa8\ub974\uace0 \uac12\uc774 \ub9de\uc9c0 \uc54a\ub294\ub2e4\uace0 \ud310\ub2e8<\/strong>: \ud569\uacc4 \uc904\uc740 \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>else\ub97c \uc0dd\ub7b5\ud558\uace0 \ube48 \uac12\uc774 \ub098\uc624\ub294 \uac83\uc744 \uc624\ub958\ub85c \uc0dd\uac01<\/strong>: \uc815\uc0c1 \ub3d9\uc791\uc785\ub2c8\ub2e4.<\/li>\n<li><strong>\uae00\uc790\uc640 \uc22b\uc790\ub97c \ud55c \uce21\uc815\uac12\uc5d0 \uc11e\uc74c<\/strong>: \uc11c\uc2dd\uacfc \uc815\ub82c\uc774 \uace4\ub780\ud574\uc9d1\ub2c8\ub2e4.<\/li>\n<li><strong>\ubcc0\uc218\ub97c IF \ubc14\uae65\uc5d0 \ubaa8\ub450 \uc815\uc758<\/strong>: \ud544\uc694 \uc5c6\ub294 \ubd84\uae30\uae4c\uc9c0 \uacc4\uc0b0\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n<h2>\ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n<ul>\n<li><strong>SWITCH<\/strong>: \uc870\uac74\uc774 \uc5ec\ub7ec \uac1c\uc77c \ub54c IF \uacb9\uce68\uc744 \ub300\uc2e0\ud569\ub2c8\ub2e4.<\/li>\n<li><strong>IFERROR<\/strong>: \uc624\ub958\uac00 \ub0ac\uc744 \ub54c \ub300\uccb4\uac12\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4.<\/li>\n<li><strong>COALESCE<\/strong>: \uccab \ubc88\uc9f8 \ube48 \uac12\uc774 \uc544\ub2cc \uac12\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4.<\/li>\n<li><strong>IF.EAGER<\/strong>: \ub450 \ubd84\uae30\ub97c \ud56d\uc0c1 \uacc4\uc0b0\ud558\ub294 \ubc29\uc2dd\uc758 IF\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n<h2>\uc815\ub9ac<\/h2>\n\n<p>IF\ub294 &#8220;\uc870\uac74\uc774 \ucc38\uc774\uba74 A, \uc544\ub2c8\uba74 B&#8221;\ub77c\ub294 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \ubd84\uae30\uc774\uace0, else\ub97c \uc0dd\ub7b5\ud558\uba74 \ube48 \uac12\uc774 \ub098\uc628\ub2e4\ub294 \uc810, \ud569\uacc4 \uc904\uc740 \ud544\ud130 \uc5c6\uc774 \uc0c8\ub85c \ud3c9\uac00\ub41c\ub2e4\ub294 \uc810, \ud55c \uce21\uc815\uac12\uc740 \ud55c \uac00\uc9c0 \ud615\uc2dd\uc73c\ub85c \ub450\ub294 \uac83\uc774 \uc88b\ub2e4\ub294 \uc810\ub9cc \uae30\uc5b5\ud574\ub3c4 \ub300\ubd80\ubd84\uc758 \ud63c\ub780\uc744 \ud53c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc870\uac74\uc774 \ub9ce\uc544\uc9c0\uba74 SWITCH\ub97c, \ub098\ub217\uc148\uc740 DIVIDE\ub97c \uba3c\uc800 \ub5a0\uc62c\ub824 \ubcf4\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<h2>\ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n<ul>\n<li>Microsoft Learn, IF function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/if-function-dax<\/li>\n<li>DAX Guide, IF: https:\/\/dax.guide\/if\/<\/li>\n<li>DAX Guide, IF.EAGER: https:\/\/dax.guide\/if-eager\/<\/li>\n<li>SQLBI, Optimizing IF and SWITCH expressions using variables: https:\/\/www.sqlbi.com\/articles\/optimizing-if-and-switch-expressions-using-variables\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>DAX IF \ud568\uc218\uc758 \ubb38\ubc95, \uc0dd\ub7b5\ud55c else\uc640 \ud569\uacc4 \uc904\uc758 \ud568\uc815, \uacc4\uc0b0 \uc5f4 \ub4f1\uae09 \ub098\ub204\uae30\uc640 \uc870\uac74\ubd80 \uce21\uc815\uac12, \ubd84\uae30 \uc548 \ubcc0\uc218 \uc704\uce58\uc640 IF.EAGER\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,20,6],"class_list":["post-40","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-if","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\/40","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=40"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/40\/revisions"}],"predecessor-version":[{"id":49,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/40\/revisions\/49"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}