{"id":37,"date":"2026-10-09T07:56:05","date_gmt":"2026-10-08T22:56:05","guid":{"rendered":"https:\/\/vera-b.com\/?p=37"},"modified":"2026-10-09T07:56:05","modified_gmt":"2026-10-08T22:56:05","slug":"dax-averagex-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ec%b2%ab-%eb%b2%88%ec%a7%b8-%ec%9d%b8%ec%88%98%ea%b0%80-%ed%8f%89%ea%b7%a0%ec%9d%98-%eb%8b%a8%ec%9c%84%eb%a5%bc-%ec%a0%95%ed%95%9c%eb%8b%a4","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=37","title":{"rendered":"DAX AVERAGEX \ud568\uc218 \uc815\ub9ac: \uccab \ubc88\uc9f8 \uc778\uc218\uac00 \ud3c9\uade0\uc758 \ub2e8\uc704\ub97c \uc815\ud55c\ub2e4"},"content":{"rendered":"\n<p>AVERAGE\ub294 \uc5f4 \ud558\ub098\uc758 \ud3c9\uade0\uc744 \uad6c\ud569\ub2c8\ub2e4. \uadf8\ub7f0\ub370 &#8220;\uc6d4\ud3c9\uade0 \ub9e4\ucd9c&#8221;, &#8220;\ud3c9\uade0 \ub9c8\uc9c4\uc728&#8221;, &#8220;\uace0\uac1d\ub2f9 \ud3c9\uade0 \uad6c\ub9e4\uc561&#8221;\ucc98\ub7fc \uc5f4\uc774 \uc544\ub2c8\ub77c \uacc4\uc0b0\ud55c \uac12\uc758 \ud3c9\uade0\uc774 \ud544\uc694\ud55c \uc21c\uac04\uc774 \uace7 \uc635\ub2c8\ub2e4. \uc774\ub54c \uc4f0\ub294 \ud568\uc218\uac00 AVERAGEX\uc785\ub2c8\ub2e4. \uc55e\uc120 <a href=\"https:\/\/vera-b.com\/?p=24\">AVERAGE \ud568\uc218 \uae00<\/a>\uc5d0\uc11c \uc8fc\ubb38\ub2f9\u00b7\uace0\uac1d\ub2f9\u00b7\uc77c\ud3c9\uade0\uc744 \uc774\ubbf8 \ud55c \ubc88 \ub2e4\ub918\uae30 \ub54c\ubb38\uc5d0, \uc774 \uae00\uc5d0\uc11c\ub294 AVERAGEX\uac00 \uc5b4\ub5bb\uac8c \ub3cc\uc544\uac00\ub294\uc9c0 \ud55c \uac00\uc9c0\uc5d0 \uc9d1\uc911\ud558\ub824 \ud569\ub2c8\ub2e4. \ubc14\ub85c &#8220;\uccab \ubc88\uc9f8 \uc778\uc218\ub85c \ubb34\uc5c7\uc744 \ub118\uae30\ub290\ub0d0\uac00 \ud3c9\uade0\uc758 \ub2e8\uc704\ub97c \uc815\ud55c\ub2e4&#8221;\ub294 \uc810\uc785\ub2c8\ub2e4.<\/p>\n\n<h2>\ubb38\ubc95<\/h2>\n\n<pre><code>AVERAGEX( &lt;\ud14c\uc774\ube14&gt;, &lt;\uc2dd&gt; )<\/code><\/pre>\n\n<p>Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub300\ub85c AVERAGEX\ub294 \uccab \ubc88\uc9f8 \uc778\uc218\uc758 \ud14c\uc774\ube14\uc744 \ud55c \uc904\uc529 \ub3cc\uba74\uc11c, \uadf8 \uc904 \uae30\uc900\uc73c\ub85c \ub450 \ubc88\uc9f8 \uc778\uc218\uc758 \uc2dd\uc744 \uacc4\uc0b0\ud55c \ub4a4, \ub098\uc628 \uac12\ub4e4\uc758 \uc0b0\uc220 \ud3c9\uade0\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4. \uccab \ubc88\uc9f8 \uc778\uc218\ub294 \ud14c\uc774\ube14 \uc774\ub984\uc774\uac70\ub098 \ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc8fc\ub294 \uc2dd\uc774\uace0, \ub450 \ubc88\uc9f8 \uc778\uc218\ub294 \uacb0\uacfc\uac00 \ud558\ub098\uc758 \uac12\uc774 \ub418\ub294 \uc2dd\uc785\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \uc18c\uc218 \ud615\ud0dc\uc758 \uc22b\uc790\uc785\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 \ud55c \uc904\uc529 \ub3c4\ub294 \ud568\uc218\ub97c \ubc18\ubcf5 \ud568\uc218(iterator)\ub77c\uace0 \ubd80\ub985\ub2c8\ub2e4.<\/p>\n\n<h2>Power BI Desktop\uc5d0\uc11c \uce21\uc815\uac12\uc73c\ub85c \ub9cc\ub4e4\uae30<\/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. \uc77c\ubc18\uc801\uc778 \uc21c\uc11c\ub294 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n<ol>\n<li>\ubcf4\uace0\uc11c \ubcf4\uae30\uc5d0\uc11c \uc624\ub978\ucabd \ud544\ub4dc \ucc3d\uc758 \ud14c\uc774\ube14(\uc608: Sales)\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc0c1\ub2e8 \ub9ac\ubcf8\uc5d0\uc11c &#8220;\uc0c8 \uce21\uc815\uac12&#8221;(\uc601\ubb38\ud310\uc740 New measure)\uc744 \ub204\ub985\ub2c8\ub2e4.<\/li>\n<li>\uc218\uc2dd \uc785\ub825\uc904\uc5d0 \uc774\ub984\uacfc \uc2dd\uc744 \uc801\uace0 Enter\ub97c \ub204\ub985\ub2c8\ub2e4.<\/li>\n<li>\ub9cc\ub4e0 \uce21\uc815\uac12\uc744 \ud45c \uc2dc\uac01\ud654\uc5d0 \uc62c\ub9ac\uace0 \uc0c1\ud488 \uac19\uc740 \uc5f4\uacfc \ud568\uaed8 \ub193\uc544 \uc904\ub9c8\ub2e4 \uac12\uc774 \uc5b4\ub5bb\uac8c \ub2ec\ub77c\uc9c0\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n<h2>\uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n<p>\uc124\uba85\ud558\ub824\uace0 \ub9cc\ub4e0 \uac00\uc0c1 \ub370\uc774\ud130\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>\uc6d4<\/th><th>\uc0c1\ud488<\/th><th>\ub9e4\ucd9c<\/th><th>\uc6d0\uac00<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>1\uc6d4<\/td><td>\ub178\ud2b8\ubd81<\/td><td>100<\/td><td>80<\/td><\/tr>\n<tr><td>1\uc6d4<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>20<\/td><td>10<\/td><\/tr>\n<tr><td>2\uc6d4<\/td><td>\ub178\ud2b8\ubd81<\/td><td>150<\/td><td>120<\/td><\/tr>\n<tr><td>2\uc6d4<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>30<\/td><td>12<\/td><\/tr>\n<tr><td>3\uc6d4<\/td><td>\ub178\ud2b8\ubd81<\/td><td>50<\/td><td>40<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\ub9e4\ucd9c \ud569\uacc4\ub294 350, \uc6d0\uac00 \ud569\uacc4\ub294 262\uc785\ub2c8\ub2e4. \uae30\ubcf8 \uce21\uc815\uac12\uc740 \uc774\ub807\uac8c \uc7a1\uc544 \ub450\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ucd1d\ub9e4\ucd9c = SUM( Sales[\ub9e4\ucd9c] )\n\ucd1d\uc6d0\uac00 = SUM( Sales[\uc6d0\uac00] )<\/code><\/pre>\n\n<h2>\ud3c9\uade0\uc758 \ub2e8\uc704\ub294 \uccab \ubc88\uc9f8 \uc778\uc218\uac00 \uc815\ud55c\ub2e4<\/h2>\n\n<p>\uac19\uc740 &#8220;\ud3c9\uade0 \ub9e4\ucd9c&#8221;\uc774\ub77c\ub3c4 \uc5b4\ub5a4 \ud14c\uc774\ube14\uc744 \ub3cc\ub9ac\ub290\ub0d0\uc5d0 \ub530\ub77c \ub73b\uc774 \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n\n<ul>\n<li><code>AVERAGEX( Sales, Sales[\ub9e4\ucd9c] )<\/code>: \ud589(\uc8fc\ubb38 \ud55c \uc904)\ub2f9 \ud3c9\uade0 \ub9e4\ucd9c. 5\ud589\uc774\ub77c 350 \u00f7 5 = <strong>70<\/strong><\/li>\n<li><code>AVERAGEX( VALUES( Sales[\uc6d4] ), [\ucd1d\ub9e4\ucd9c] )<\/code>: \uc6d4\ub2f9 \ud3c9\uade0 \ub9e4\ucd9c. 3\uac1c\uc6d4\uc774\ub77c 350 \u00f7 3 = \uc57d <strong>116.7<\/strong><\/li>\n<li><code>AVERAGEX( VALUES( Sales[\uc0c1\ud488] ), [\ucd1d\ub9e4\ucd9c] )<\/code>: \uc0c1\ud488\ub2f9 \ud3c9\uade0 \ub9e4\ucd9c. \uc0c1\ud488\ubcc4 \ucd1d\ub9e4\ucd9c\uc774 \ub178\ud2b8\ubd81 300, \ub9c8\uc6b0\uc2a4 50\uc774\ub77c (300 + 50) \u00f7 2 = <strong>175<\/strong><\/li>\n<\/ul>\n\n<p>\uc138 \uc2dd\uc758 \ub450 \ubc88\uc9f8 \uc778\uc218\ub294 \ubaa8\ub450 &#8220;\ub9e4\ucd9c&#8221;\uc778\ub370 \uacb0\uacfc\ub294 70, 116.7, 175\ub85c \uc804\ud600 \ub2e4\ub985\ub2c8\ub2e4. \uccab \ubc88\uc9f8 \uc778\uc218\uac00 &#8220;\ubb34\uc5c7 \ud55c \uac1c\ub2f9 \ud3c9\uade0\uc778\uac00&#8221;\ub97c \uc815\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc5d0 &#8220;\ud3c9\uade0 \ub9e4\ucd9c&#8221;\uc774\ub77c\uace0\ub9cc \uc4f0\uba74 \uc77d\ub294 \uc0ac\ub78c\uc774 \uc5b4\ub290 \ud3c9\uade0\uc778\uc9c0 \uc54c \uc218 \uc5c6\uc73c\ub2c8, \ub2e8\uc704\ub97c \ud568\uaed8 \uc801\ub294 \ud3b8\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \uc774 \ud2b9\uc9d5\uc740 DAX Guide\uac00 AVERAGEX\uc758 \ub300\ud45c \uc6a9\ub3c4\ub85c \uaf3d\ub294 &#8220;\uace0\uac1d\uc774\ub098 \ub0a0\uc9dc \uac19\uc740 \ud14c\uc774\ube14\uc744 \ub3cc\uba74\uc11c \uce21\uc815\uac12\uc744 \ud3c9\uade0 \ub0b8\ub2e4&#8221;\ub294 \uc124\uba85\uacfc\ub3c4 \uc774\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \ud3c9\uade0 \ub9c8\uc9c4\uc728 (\ud589 \ud3c9\uade0 vs \uac00\uc911 \ud3c9\uade0)<\/h2>\n\n<p>\ub9c8\uc9c4\uc728\uc740 (\ub9e4\ucd9c &#8211; \uc6d0\uac00) \u00f7 \ub9e4\ucd9c\uc785\ub2c8\ub2e4. \ud589\ub9c8\ub2e4 \ub9c8\uc9c4\uc728\uc744 \uad6c\ud55c \ub4a4 \ud3c9\uade0\uc744 \ub0b4\uba74 \uc774\ub807\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ud3c9\uade0\ub9c8\uc9c4\uc728_\ud589\ud3c9\uade0 =\nAVERAGEX(\n    Sales,\n    DIVIDE( Sales[\ub9e4\ucd9c] - Sales[\uc6d0\uac00], Sales[\ub9e4\ucd9c] )\n)<\/code><\/pre>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc6d4<\/th><th>\uc0c1\ud488<\/th><th>\ub9e4\ucd9c<\/th><th>\uc6d0\uac00<\/th><th>\ub9c8\uc9c4\uc728<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>1\uc6d4<\/td><td>\ub178\ud2b8\ubd81<\/td><td>100<\/td><td>80<\/td><td>20%<\/td><\/tr>\n<tr><td>1\uc6d4<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>20<\/td><td>10<\/td><td>50%<\/td><\/tr>\n<tr><td>2\uc6d4<\/td><td>\ub178\ud2b8\ubd81<\/td><td>150<\/td><td>120<\/td><td>20%<\/td><\/tr>\n<tr><td>2\uc6d4<\/td><td>\ub9c8\uc6b0\uc2a4<\/td><td>30<\/td><td>12<\/td><td>60%<\/td><\/tr>\n<tr><td>3\uc6d4<\/td><td>\ub178\ud2b8\ubd81<\/td><td>50<\/td><td>40<\/td><td>20%<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\ub2e4\uc12f \ud589\uc758 \ub9c8\uc9c4\uc728\uc740 20%, 50%, 20%, 60%, 20%\uc774\uace0 \ud3c9\uade0\uc740 (0.2 + 0.5 + 0.2 + 0.6 + 0.2) \u00f7 5 = <strong>34%<\/strong>\uc785\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \ud68c\uc0ac \uc804\uccb4\uc758 \uc2e4\uc81c \ub9c8\uc9c4\uc728\uc740 \uc774\ub807\uac8c \uad6c\ud569\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ub9c8\uc9c4\uc728_\uc804\uccb4 =\nDIVIDE( [\ucd1d\ub9e4\ucd9c] - [\ucd1d\uc6d0\uac00], [\ucd1d\ub9e4\ucd9c] )<\/code><\/pre>\n\n<p>(350 &#8211; 262) \u00f7 350 = 88 \u00f7 350 = \uc57d <strong>25.1%<\/strong>\uc785\ub2c8\ub2e4. 34%\uc640 25.1%\ub294 9%\ud3ec\uc778\ud2b8 \uac00\uae4c\uc774 \ucc28\uc774\uac00 \ub0a9\ub2c8\ub2e4. \ub9c8\uc9c4\uc728\uc774 \ub192\uc740 \ub9c8\uc6b0\uc2a4\ub294 \ub9e4\ucd9c \uaddc\ubaa8\uac00 \uc791\uace0, \ub9c8\uc9c4\uc728\uc774 \ub0ae\uc740 \ub178\ud2b8\ubd81\uc740 \ub9e4\ucd9c \uaddc\ubaa8\uac00 \ud070\ub370, \ud589 \ud3c9\uade0\uc740 \uaddc\ubaa8\ub97c \ubb34\uc2dc\ud558\uace0 \ubaa8\ub4e0 \ud589\uc5d0 \uac19\uc740 \ubb34\uac8c\ub97c \uc8fc\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ube44\uc728\uc758 \ud3c9\uade0\uc744 \uad6c\ud560 \ub54c\ub294 &#8220;\ud589\ub9c8\ub2e4 \uac19\uc740 \ubb34\uac8c\ub85c \ud3c9\uade0 \ub0bc \uac83\uc778\uac00, \ub9e4\ucd9c \uaddc\ubaa8\ub85c \uac00\uc911\ud574\uc11c \ud569\uc0b0\ud560 \uac83\uc778\uac00&#8221;\ub97c \uba3c\uc800 \uc815\ud574\uc57c \ud569\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc5d0 \uc4f0\ub294 \ub9c8\uc9c4\uc728\uc740 \ub300\uac1c \uac00\uc911 \ucabd(\uc804\uccb4 \ub9c8\uc9c4 \u00f7 \uc804\uccb4 \ub9e4\ucd9c)\uc774 \ub9de\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. AVERAGE \uae00\uc5d0\uc11c \ubcf8 \ud3c9\uade0 \ub2e8\uac00\uc758 \ud568\uc815\uacfc \uac19\uc740 \uc774\uc57c\uae30\uc785\ub2c8\ub2e4.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \uc6d4\ud3c9\uade0 \ub9e4\ucd9c\uacfc \uc0c1\ud488\ubcc4 \uc6d4\ud3c9\uade0<\/h2>\n\n<p>&#8220;\ud55c \ub2ec \ud3c9\uade0 \uc5bc\ub9c8\ub098 \ud30c\ub294\uac00&#8221;\ub294 \uc6d4 \ubaa9\ub85d \uc704\uc5d0\uc11c \ucd1d\ub9e4\ucd9c \uce21\uc815\uac12\uc744 \ud3c9\uade0 \ub0b4\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n<pre><code>\uc6d4\ud3c9\uade0\ub9e4\ucd9c =\nAVERAGEX(\n    VALUES( Sales[\uc6d4] ),\n    [\ucd1d\ub9e4\ucd9c]\n)<\/code><\/pre>\n\n<p>VALUES\uac00 \ud604\uc7ac \ud544\ud130 \uc0c1\ud0dc\uc758 \uc6d4 \ubaa9\ub85d(1\uc6d4, 2\uc6d4, 3\uc6d4)\uc744 \ub3cc\ub824\uc8fc\uace0, AVERAGEX\uac00 \uadf8 \uc6d4\uc744 \ud55c \ub2ec\uc529 \ub3cc\uba74\uc11c <code>[\ucd1d\ub9e4\ucd9c]<\/code>\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4. \uc774\ub54c &#8220;\uc9c0\uae08 \ub3c4\ub294 \uc6d4&#8221;\uc774 \uc790\ub3d9\uc73c\ub85c \ud544\ud130\ub85c \ubc14\ub00c\ub294 \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4. \uc774 \uac1c\ub150\uc740 <a href=\"https:\/\/vera-b.com\/?p=19\">CALCULATE \ud568\uc218 \uae00<\/a>\uc5d0 \uc815\ub9ac\ud574 \ub450\uc5c8\uc2b5\ub2c8\ub2e4. \uc6d4\ubcc4 \ucd1d\ub9e4\ucd9c\uc740 1\uc6d4 120, 2\uc6d4 180, 3\uc6d4 50\uc774\ub77c \uc6d4\ud3c9\uade0\uc740 350 \u00f7 3 = \uc57d <strong>116.7<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n<p>\uc0c1\ud488\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc774\ub807\uac8c \ub098\ub269\ub2c8\ub2e4.<\/p>\n\n<table style=\"border-collapse:collapse;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc0c1\ud488<\/th><th>\uc6d4\ud3c9\uade0\ub9e4\ucd9c<\/th><th>\uacc4\uc0b0<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\ub178\ud2b8\ubd81<\/td><td>100<\/td><td>(100 + 150 + 50) \u00f7 3<\/td><\/tr>\n<tr><td>\ub9c8\uc6b0\uc2a4<\/td><td>25<\/td><td>(20 + 30) \u00f7 2<\/td><\/tr>\n<tr><td>\ud569\uacc4<\/td><td>116.7<\/td><td>(120 + 180 + 50) \u00f7 3<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>\ub9c8\uc6b0\uc2a4\ub294 3\uc6d4 \ud310\ub9e4 \ud589\uc774 \uc5c6\uc5b4\uc11c, \ub9c8\uc6b0\uc2a4 \ud544\ud130 \uc544\ub798\uc758 \uc6d4 \ubaa9\ub85d\uc5d0\ub294 1\uc6d4\uacfc 2\uc6d4\ub9cc \ub4e4\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c (20 + 30) \u00f7 2 = 25\uc785\ub2c8\ub2e4. 3\uc6d4\uc744 &#8220;\ub9e4\ucd9c 0&#8243;\uc73c\ub85c \ubcf4\uace0 (20 + 30 + 0) \u00f7 3 = \uc57d 16.7\ub85c \uad6c\ud558\uace0 \uc2f6\ub2e4\uba74 \ubcc4\ub3c4\uc758 \ub0a0\uc9dc(\uc6d4) \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4 \uadf8 \uc704\uc5d0\uc11c \ub3cc\ub824\uc57c \ud569\ub2c8\ub2e4. \uc774\ub54c \ub9e4\ucd9c\uc774 \uc5c6\ub294 \uc6d4\uc758 \ucd1d\ub9e4\ucd9c\uc740 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12\uc774\uace0, AVERAGEX\ub294 \ube48 \uac12\uc744 \ud3c9\uade0\uc5d0\uc11c \ube7c\uae30 \ub54c\ubb38\uc5d0 \uc774 \uacbd\uc6b0\uc5d0\ub3c4 \uadf8\ub0e5 \ub450\uba74 25\uac00 \ub098\uc635\ub2c8\ub2e4. \ube48 \uac12\uc744 0\uc73c\ub85c \uc138\ub824\uba74 \uc2dd\uc744 <code>[\ucd1d\ub9e4\ucd9c] + 0<\/code>\ucc98\ub7fc \ubc14\uafd4\uc57c \ud569\ub2c8\ub2e4. \uc774 \ud568\uc815\uc744 \uae38\uac8c \ub2e4\ub8ec \uae00\uc774 SQLBI\uc758 &#8220;\uc77c\ud3c9\uade0 \uacc4\uc0b0\uc758 \uc228\uc740 \ubcf5\uc7a1\uc131&#8221;\uc774\uace0, \uad00\uce21 \uae30\uac04\uc758 \uc2dc\uc791\uacfc \ub05d\uc744 \uba3c\uc800 \uc815\ud558\ub294 \ud574\ubc95\uc774 \uc18c\uac1c\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc2dd\uc774 \uae38\uc5b4\uc11c \uc774 \uae00\uc5d0\uc11c\ub294 \ub2e4\ub8e8\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n\n<h2>\ube48 \uac12\uc740 \ube7c\uace0 0\uc740 \uc13c\ub2e4<\/h2>\n\n<p>DAX Guide\uc758 \uc608\uc2dc\uac00 \uc774 \uaddc\uce59\uc744 \uac00\uc7a5 \uac04\ub2e8\ud558\uac8c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \uc2dd\uc758 \uacb0\uacfc\uac00 1, 2, 3, \ube48 \uac12\uc774\uba74 \ud3c9\uade0\uc740 2\uc774\uace0, 1, 2, 3, 0\uc774\uba74 \ud3c9\uade0\uc740 1.5\uc785\ub2c8\ub2e4. \ube48 \uac12\uc740 \ud3c9\uade0\uc744 \ub0bc \ub54c \uac1c\uc218\uc5d0\uc11c\ub3c4 \ube60\uc9c0\uc9c0\ub9cc 0\uc740 \ud55c \uac1c\ub85c \uc138\uc5b4\uc9c0\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\ub3c4 AVERAGEX\uac00 \uadf8 \uc678\uc758 \uaddc\uce59\uc740 AVERAGE\ub97c \ub530\ub77c\uc11c \uc22b\uc790\uac00 \uc544\ub2cc \uac12\uc774\ub098 \ube44\uc5b4 \uc788\ub294 \uac12\uc740 \ud3c9\uade0\uc5d0 \ub123\uc9c0 \uc54a\ub294\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n<h2>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \uc870\uac74\uc5d0 \ub9de\ub294 \ud56d\ubaa9\ub9cc \ud3c9\uade0 \ub0b4\uae30<\/h2>\n\n<p>&#8220;\ub9e4\ucd9c\uc774 100 \uc774\uc0c1\uc774\uc5c8\ub358 \ub2ec\ub9cc\uc758 \ud3c9\uade0&#8221;\ucc98\ub7fc \uc77c\ubd80\ub9cc \ud3c9\uade0 \ub0b4\ub824\uba74 \uccab \ubc88\uc9f8 \uc778\uc218\ub97c FILTER\ub85c \uac78\ub7ec\uc11c \ub118\uae41\ub2c8\ub2e4.<\/p>\n\n<pre><code>\ud070\ub2ec\ud3c9\uade0\ub9e4\ucd9c =\nAVERAGEX(\n    FILTER( VALUES( Sales[\uc6d4] ), [\ucd1d\ub9e4\ucd9c] &gt;= 100 ),\n    [\ucd1d\ub9e4\ucd9c]\n)<\/code><\/pre>\n\n<p>\ucd1d\ub9e4\ucd9c\uc774 100 \uc774\uc0c1\uc778 \ub2ec\uc740 1\uc6d4(120)\uacfc 2\uc6d4(180)\uc774\ub77c \uacb0\uacfc\ub294 (120 + 180) \u00f7 2 = <strong>150<\/strong>\uc785\ub2c8\ub2e4. 3\uc6d4(50)\uc740 \ud3c9\uade0\uc5d0\uc11c \ube60\uc9d1\ub2c8\ub2e4. \ud55c\ub450 \ub2ec\uc758 \uc774\uc0c1\uac12\uc774\ub098 \uadf9\ub2e8\uc801\uc73c\ub85c \uc791\uc740 \uac12\uc744 \ube7c\uace0 \ubcf4\uace0 \uc2f6\uc744 \ub54c \uc774\ub807\uac8c \uc501\ub2c8\ub2e4. \ub2e4\ub9cc \ubb34\uc5c7\uc744 \uc774\uc0c1\uac12\uc73c\ub85c \ubcfc\uc9c0 \uae30\uc900\uc740 \uc9c1\uc811 \uc815\ud574\uc57c \ud558\uace0, \uc81c\uc678\ud55c \uae30\uc900\uc740 \ubcf4\uace0\uc11c\uc5d0 \ud568\uaed8 \uc801\uc5b4 \ub450\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n<h2>AVERAGE\uc640 AVERAGEX, \uc5b8\uc81c \ubb34\uc5c7\uc744 \uc4f8\uae4c<\/h2>\n\n<table style=\"border-collapse:collapse; width:100%;\" border=\"1\" cellpadding=\"8\">\n<thead><tr><th>\uc0c1\ud669<\/th><th>\uc4f8 \ud568\uc218<\/th><\/tr><\/thead>\n<tbody>\n<tr><td>\uc5f4 \ud558\ub098\uc758 \ud3c9\uade0<\/td><td>AVERAGE<\/td><\/tr>\n<tr><td>\ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \uac12(\uc218\ub7c9\u00d7\ub2e8\uac00 \ub4f1)\uc758 \ud3c9\uade0<\/td><td>AVERAGEX( \ud14c\uc774\ube14, \uc2dd )<\/td><\/tr>\n<tr><td>\uc6d4, \uace0\uac1d, \uc0c1\ud488 \uac19\uc740 \ubaa9\ub85d \uc704\uc5d0\uc11c \uce21\uc815\uac12\uc758 \ud3c9\uade0<\/td><td>AVERAGEX( VALUES( \uc5f4 ), [\uce21\uc815\uac12] )<\/td><\/tr>\n<tr><td>\uc77c\ubd80\ub9cc \uac78\ub7ec\uc11c \ud3c9\uade0<\/td><td>AVERAGEX( FILTER( &#8230; ), \uc2dd ) \ub610\ub294 CALCULATE\uc640 AVERAGE<\/td><\/tr>\n<tr><td>\ube44\uc728(\ub9c8\uc9c4\uc728 \ub4f1)\uc758 \ud3c9\uade0<\/td><td>\uac00\uc911 \ubc29\uc2dd( \ud569\uacc4 \u00f7 \ud569\uacc4 )\uc744 \uba3c\uc800 \uac80\ud1a0<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n<p>DAX Guide\uc5d0 \ub530\ub974\uba74 \uc5f4 \ud558\ub098\uc5d0 \uc4f4 AVERAGE\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c AVERAGEX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0 \uc131\ub2a5 \ucc28\uc774\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub2c8 \uc5f4 \ud558\ub098\uc758 \ud3c9\uade0\uc774\ub77c\uba74 \uc77d\uae30 \uc26c\uc6b4 AVERAGE\ub97c, \uc2dd\uc774 \ud544\uc694\ud558\uba74 AVERAGEX\ub97c \uc4f0\uba74 \ub429\ub2c8\ub2e4. \ub2e4\ub9cc AVERAGEX\ub294 \ud589\uc744 \ud558\ub098\uc529 \ub3c4\ub294 \ud568\uc218\ub77c\uc11c, \ubc18\ubcf5 \uc548\uc5d0 \ubb34\uac70\uc6b4 \uacc4\uc0b0\uc774 \ub4e4\uc5b4\uac00\uba74 \uadf8\ub9cc\ud07c \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n<h2>\uc54c\uc544\ub458 \uc810<\/h2>\n\n<ul>\n<li>DirectQuery \ubaa8\ub4dc\uc5d0\uc11c\ub294 \uacc4\uc0b0 \uc5f4\uc774\ub098 \ud589 \uc218\uc900 \ubcf4\uc548 \uaddc\uce59 \uc548\uc5d0\uc11c AVERAGEX\ub97c \uc4f8 \uc218 \uc5c6\ub2e4\uace0 Microsoft \ubb38\uc11c\uc5d0 \uc801\ud600 \uc788\uc2b5\ub2c8\ub2e4. DAX Guide\ub294 \uce21\uc815\uac12\uacfc \uacc4\uc0b0 \uc5f4\uc5d0\uc11c \uc9c0\uc6d0\ub41c\ub2e4\uace0 \uc548\ub0b4\ud574 \uc124\uba85\uc774 \ub2e4\ub974\ub2c8, \uc4f0\ub294 \ud658\uacbd\uc5d0\uc11c \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/li>\n<li>\uc2dd \uc548\uc5d0\uc11c \uc5ec\ub7ec \uc5f0\uc0b0\uc744 \uc4f8 \ub54c\ub294 \uad04\ud638\ub85c \uacc4\uc0b0 \uc21c\uc11c\ub97c \ubd84\uba85\ud788 \ud574\uc57c \ud55c\ub2e4\uace0 Microsoft \ubb38\uc11c\uac00 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n<li>\ub450 \ubc88\uc9f8 \uc778\uc218\uc758 \uc2dd\uc740 \ud55c \uc904\ub9c8\ub2e4 \ud558\ub098\uc758 \uac12\uc774 \ub098\uc624\ub294 \uc2dd\uc774\uc5b4\uc57c \ud569\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>\ud3c9\uade0\uc758 \ub2e8\uc704\ub97c \uc815\ud558\uc9c0 \uc54a\uace0 &#8220;\ud3c9\uade0 \ub9e4\ucd9c&#8221;\uc774\ub77c\uace0 \ud45c\uae30<\/strong>: \ud589\ub2f9\uc778\uc9c0, \uc6d4\ub2f9\uc778\uc9c0, \uc0c1\ud488\ub2f9\uc778\uc9c0 \ubc1d\ud788\uc138\uc694.<\/li>\n<li><strong>\ube44\uc728\uc744 \ud589\ub9c8\ub2e4 \uad6c\ud574 \ud3c9\uade0<\/strong>: \uaddc\ubaa8\uac00 \ub2e4\ub978 \ud589\uc774 \uc11e\uc774\uba74 \uc2e4\uc81c \ube44\uc728\uacfc \ud06c\uac8c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/li>\n<li><strong>\ub9e4\ucd9c\uc774 \uc5c6\ub294 \ub2ec\uc774 0\uc73c\ub85c \ud3c9\uade0\uc5d0 \ub4e4\uc5b4\uac14\ub2e4\uace0 \ucc29\uac01<\/strong>: \ube48 \uac12\uc740 \ube60\uc9d1\ub2c8\ub2e4.<\/li>\n<li><strong>AVERAGE( Sales[\ub9e4\ucd9c] * Sales[\ub2e8\uac00] )\ucc98\ub7fc \uc2dd\uc744 AVERAGE\uc5d0 \ubc14\ub85c \ub123\uc74c<\/strong>: AVERAGE\ub294 \uc5f4\ub9cc \ubc1b\uc73c\ub2c8 AVERAGEX\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n<h2>\ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n<ul>\n<li><strong>AVERAGE<\/strong>: \uc5f4 \ud558\ub098\uc758 \ud3c9\uade0<\/li>\n<li><strong>SUMX, MINX, MAXX, COUNTX<\/strong>: \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \ub4a4 \ud569\uacc4, \ucd5c\uc18c, \ucd5c\ub300, \uac1c\uc218\ub97c \uad6c\ud558\ub294 \ubc18\ubcf5 \ud568\uc218<\/li>\n<li><strong>MEDIAN<\/strong>: \ud3c9\uade0 \ub300\uc2e0 \uc911\uc559\uac12\uc774 \ud544\uc694\ud560 \ub54c<\/li>\n<\/ul>\n\n<h2>\uc815\ub9ac<\/h2>\n\n<p>AVERAGEX\ub294 &#8220;\uccab \ubc88\uc9f8 \uc778\uc218\uc758 \ud14c\uc774\ube14\uc744 \ud55c \uc904\uc529 \ub3cc\uba70 \ub450 \ubc88\uc9f8 \uc778\uc218\uc758 \uc2dd\uc744 \ud3c9\uade0 \ub0b8\ub2e4&#8221;\ub294 \ud55c \ubb38\uc7a5\uc73c\ub85c \uc694\uc57d\ub429\ub2c8\ub2e4. \uc5b4\ub5a4 \ud14c\uc774\ube14\uc744 \ub3cc\ub9ac\ub290\ub0d0\uac00 \ud3c9\uade0\uc758 \ub2e8\uc704\ub97c \uc815\ud558\uace0, \ube48 \uac12\uc740 \ube60\uc9c0\uace0 0\uc740 \uc138\uc5b4\uc9c4\ub2e4\ub294 \uaddc\uce59, \uadf8\ub9ac\uace0 \ube44\uc728\uc758 \ud3c9\uade0\uc740 \uac00\uc911 \ubc29\uc2dd\uc744 \uba3c\uc800 \uac80\ud1a0\ud574\uc57c \ud55c\ub2e4\ub294 \uc810\ub9cc \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<h2>\ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n<ul>\n<li>Microsoft Learn, AVERAGEX function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/averagex-function-dax<\/li>\n<li>Microsoft Learn, AVERAGE function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/average-function-dax<\/li>\n<li>DAX Guide, AVERAGEX: https:\/\/dax.guide\/averagex\/<\/li>\n<li>SQLBI, The hidden complexity of a daily average in DAX: https:\/\/www.sqlbi.com\/articles\/the-hidden-complexity-of-a-daily-average-in-dax\/<\/li>\n<li>SQLBI, Context transition in DAX explained visually: https:\/\/www.sqlbi.com\/articles\/context-transition-in-dax-explained-visually\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>DAX AVERAGEX \ud568\uc218\uc5d0\uc11c \uccab \ubc88\uc9f8 \uc778\uc218\uac00 \ud3c9\uade0\uc758 \ub2e8\uc704\ub97c \uc815\ud55c\ub2e4\ub294 \uc810, \ud589 \ud3c9\uade0\uacfc \uac00\uc911 \ud3c9\uade0\uc758 \ub9c8\uc9c4\uc728 \ucc28\uc774, \uc6d4\ud3c9\uade0\uacfc \uc870\uac74\ubd80 \ud3c9\uade0\uc744 \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":[9,18,4,6],"class_list":["post-37","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-average","tag-averagex","tag-dax","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\/37","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=37"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/37\/revisions"}],"predecessor-version":[{"id":45,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/37\/revisions\/45"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}