{"id":22,"date":"2026-10-01T22:51:00","date_gmt":"2026-10-01T13:51:00","guid":{"rendered":"https:\/\/vera-b.com\/?p=22"},"modified":"2026-10-01T22:51:00","modified_gmt":"2026-10-01T13:51:00","slug":"dax-sum-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ec%97%b4-%ed%95%a9%ea%b3%84%eb%b6%80%ed%84%b0-sumx%eb%a1%9c-%eb%84%98%ec%96%b4%ea%b0%80%eb%8a%94-%ea%b8%b0%ec%a4%80%ea%b9%8c%ec%a7%80","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=22","title":{"rendered":"DAX SUM \ud568\uc218 \uc815\ub9ac: \uc5f4 \ud569\uacc4\ubd80\ud130 SUMX\ub85c \ub118\uc5b4\uac00\ub294 \uae30\uc900\uae4c\uc9c0"},"content":{"rendered":"\n

DAX\ub97c \ucc98\uc74c \ubc30\uc6b8 \ub54c \uac00\uc7a5 \uba3c\uc800 \uc4f0\ub294 \ud568\uc218\uac00 SUM\uc785\ub2c8\ub2e4. \uc5d1\uc140\uc758 SUM\uacfc \uc774\ub984\uc774 \uac19\uc544\uc11c “\uc544, \uadf8\uac70\uad6c\ub098” \ud558\uace0 \ub118\uc5b4\uac00\uae30 \uc26c\uc6b4\ub370, \uc5d1\uc140\ucc98\ub7fc \uc140 \ubc94\uc704\ub97c \uc7a1\ub294 \ud568\uc218\uac00 \uc544\ub2c8\ub77c\ub294 \uc810\uc5d0\uc11c \ud55c \ubc88 \uc9da\uace0 \uac00\ub294 \uac8c \uc88b\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc5b4\ub290 \uc21c\uac04 “\uc218\ub7c9 \uacf1\ud558\uae30 \ub2e8\uac00\ub97c \ud569\uccd0\uc57c \ud558\ub294\ub370 SUM\uc73c\ub85c\ub294 \uc548 \ub418\ub124?” \ud558\ub294 \uc9c0\uc810\uc774 \ubc18\ub4dc\uc2dc \uc635\ub2c8\ub2e4. \uadf8 \uacbd\uacc4\uac00 \uc5b4\ub514\uc778\uc9c0\uae4c\uc9c0 \uc815\ub9ac\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n

SUM\uc740 \uc774\ub7f0 \ud568\uc218\uc785\ub2c8\ub2e4<\/h2>\n\n

SUM\uc740 \uc5f4 \ud558\ub098\uc5d0 \ub4e4\uc5b4 \uc788\ub294 \uc22b\uc790\ub97c \ubaa8\ub450 \ub354\ud574\uc11c<\/strong> \uac12\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub3c4 \ud55c \uc904\uc785\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \uc18c\uc218(decimal) \ud615\ud0dc\uc758 \uc22b\uc790\uc785\ub2c8\ub2e4.<\/p>\n\n

SUM( <\uc5f4> )<\/code><\/pre>\n\n
\uc778\uc218\ub294 \uc5f4 \ud558\ub098\ubfd0\uc785\ub2c8\ub2e4. \uc140 \ubc94\uc704\ub098 \uacc4\uc0b0\uc2dd\uc740 \ub123\uc744 \uc218 \uc5c6\uace0, \ubaa8\ub378\uc5d0 \uc788\ub294 \ud14c\uc774\ube14\uc758 \uc5f4 \uc774\ub984\uc744 \ud14c\uc774\ube14[\uc5f4]<\/code> \ud615\ud0dc\ub85c \uc801\uc2b5\ub2c8\ub2e4. \uc5f4 \uc774\ub984\uc740 \ub300\uad04\ud638, \uacf5\ubc31\uc774 \uc788\ub294 \ud14c\uc774\ube14 \uc774\ub984\uc740 \uc791\uc740\ub530\uc634\ud45c\ub85c \uac10\uc309\ub2c8\ub2e4.<\/p>\n\n
\ucd1d\uc218\ub7c9 = SUM( Sales[\uc218\ub7c9] )<\/code><\/pre>\n\n
\uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
\uc774 \uae00\uc758 \ubaa8\ub4e0 \uc608\uc81c\ub294 \uc544\ub798 \ud45c\ub97c \uae30\uc900\uc73c\ub85c \ud569\ub2c8\ub2e4. \uc124\uba85\ud558\ub824\uace0 \uc81c\uac00 \uc784\uc758\ub85c \ub9cc\ub4e0 \uac00\uc0c1 \ub370\uc774\ud130<\/strong>\uc774\uace0, \ub2e8\uac00\ub294 \ub9cc\uc6d0 \ub2e8\uc704\uc785\ub2c8\ub2e4. \uacb0\uacfc \uc22b\uc790\ub3c4 Power BI\uc5d0\uc11c \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uacc4\uc0b0 \uacfc\uc815\uc744 \ub530\ub77c\uac00\uba70 \uc9c1\uc811 \uad6c\ud55c \uac12\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc8fc\ubb38<\/th>\uc0c1\ud488<\/th>\uc218\ub7c9<\/th>\ub2e8\uac00<\/th><\/tr><\/thead>\n
1<\/td>\ub178\ud2b8\ubd81<\/td>1<\/td>120<\/td><\/tr>\n
2<\/td>\ub9c8\uc6b0\uc2a4<\/td>3<\/td>4<\/td><\/tr>\n
3<\/td>\ubaa8\ub2c8\ud130<\/td>2<\/td>20<\/td><\/tr>\n
4<\/td>\ub9c8\uc6b0\uc2a4<\/td>5<\/td>4<\/td><\/tr>\n
5<\/td>\ub178\ud2b8\ubd81<\/td>2<\/td>100<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
\uc218\ub7c9 \uc5f4\uc744 \uc804\ubd80 \ub354\ud558\uba74 1 + 3 + 2 + 5 + 2 = 13\uc785\ub2c8\ub2e4. \uc704\uc758 \ucd1d\uc218\ub7c9<\/code> \uce21\uc815\uac12\uc774 \ubc18\ud658\ud558\ub294 \uac12\uc774 \ubc14\ub85c 13\uc785\ub2c8\ub2e4.<\/p>\n\n
\uc0c1\ud488\ubcc4\ub85c \ub098\ub220 \ubcf4\uba74<\/h2>\n\n
\uc774 \uce21\uc815\uac12\uc744 \uc0c1\ud488\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \ubcc4\ub3c4\uc758 \uc870\uac74 \uc5c6\uc774\ub3c4 \uc54c\uc544\uc11c \ub098\ub258\uc5b4 \uacc4\uc0b0\ub429\ub2c8\ub2e4. \uce21\uc815\uac12\uc740 \ubcf4\uace0\uc11c\uc758 \uac01 \uc140\uc774 \uac00\uc9c4 \ud544\ud130 \uc0c1\ud0dc\uc5d0 \ub9de\ucdb0 \ub2e4\uc2dc \uacc4\uc0b0\ub418\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc0c1\ud488<\/th>\ucd1d\uc218\ub7c9<\/th><\/tr><\/thead>\n
\ub178\ud2b8\ubd81<\/td>3<\/td><\/tr>\n
\ub9c8\uc6b0\uc2a4<\/td>8<\/td><\/tr>\n
\ubaa8\ub2c8\ud130<\/td>2<\/td><\/tr>\n
\ud569\uacc4<\/td>13<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
\uac12\uc774 \uc5c6\uc73c\uba74 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12<\/h2>\n\n
DAX Guide\uc5d0\ub294 \uc774\ub7f0 \uc124\uba85\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \uc5f4\uc5d0 \uac12\uc774 \ub4e4\uc5b4 \uc788\ub294 \ud589\uc774 \ud558\ub098\ub3c4 \uc5c6\uc73c\uba74 \uacb0\uacfc\ub294 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12(BLANK)<\/strong>\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub370\uc774\ud130\uc5d0 \ud55c \ubc88\ub3c4 \ub4f1\uc7a5\ud558\uc9c0 \uc54a\uc740 “\ud0a4\ubcf4\ub4dc”\ub85c \ud544\ud130\ub97c \uac78\uba74, \ud45c\uc5d0\uc11c\ub294 0\uc774 \uc544\ub2c8\ub77c \uc544\ubb34\uac83\ub3c4 \ud45c\uc2dc\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. 0\uc73c\ub85c \ubcf4\uc5ec\uc8fc\uace0 \uc2f6\ub2e4\uba74 \uce21\uc815\uac12 \ub05d\uc5d0 + 0<\/code>\uc744 \ubd99\uc774\ub294 \uc2dd\uc73c\ub85c \ucc98\ub9ac\ud558\uae30\ub3c4 \ud558\ub294\ub370, \uc774 \uacbd\uc6b0 \ub370\uc774\ud130\uac00 \uc5c6\ub294 \ud56d\ubaa9\uae4c\uc9c0 \uc904\uc774 \ub298\uc5b4\ub098 \ud45c\uac00 \uae38\uc5b4\uc9c8 \uc218 \uc788\uc73c\ub2c8 \uc758\ub3c4\ub97c \uba3c\uc800 \uc0dd\uac01\ud574 \ubcf4\ub294 \uac8c \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\uc870\uac74\uc744 \uac78\uc5b4\uc11c \ub354\ud558\uace0 \uc2f6\uc744 \ub54c<\/h2>\n\n
“\ub178\ud2b8\ubd81 \uc218\ub7c9\ub9cc \ub530\ub85c \ubcf4\uace0 \uc2f6\ub2e4”\uba74 CALCULATE\ub85c \ud544\ud130\ub97c \ubc14\uafd4 \uc90d\ub2c8\ub2e4.<\/p>\n\n
\ub178\ud2b8\ubd81 \uc218\ub7c9 =\nCALCULATE(\n    SUM( Sales[\uc218\ub7c9] ),\n    Sales[\uc0c1\ud488] = \"\ub178\ud2b8\ubd81\"\n)<\/code><\/pre>\n\n
\uacb0\uacfc\ub294 1 + 2 = 3\uc785\ub2c8\ub2e4. CALCULATE\uac00 \uc5b4\ub5bb\uac8c \ud544\ud130\ub97c \ubc14\uafb8\ub294\uc9c0\ub294 CALCULATE \ud568\uc218 \uc815\ub9ac<\/a> \uae00\uc5d0 \uc790\uc138\ud788 \uc801\uc5b4 \ub450\uc5c8\uc2b5\ub2c8\ub2e4. Microsoft\uc758 SUM \ubb38\uc11c\uc5d0\ub294 “\ud569\uc0b0\ud560 \uac12\uc744 \uac78\ub7ec\ub0b4\uace0 \uc2f6\ub2e4\uba74 SUMX\ub97c \uc4f8 \uc218 \uc788\ub2e4”\ub294 \uc548\ub0b4\uac00 \uc788\ub294\ub370, \uc2e4\ubb34\uc5d0\uc11c\ub294 CALCULATE\ub85c \ud544\ud130\ub97c \uac70\ub294 \ubc29\uc2dd\uc744 \ub354 \uc790\uc8fc \ubcf4\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n
SUM\uc73c\ub85c\ub294 \uc548 \ub418\ub294 \uc21c\uac04<\/h2>\n\n
\uc774\uc81c \ub9e4\ucd9c\uc744 \uad6c\ud574 \ubd05\uc2dc\ub2e4. \ub9e4\ucd9c\uc740 “\uc218\ub7c9 \u00d7 \ub2e8\uac00”\ub97c \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \ub4a4\uc5d0 \ub354\ud574\uc57c \ud569\ub2c8\ub2e4. \ucc98\uc74c \ud574 \ubcf4\uba74 \uc544\ub798\ucc98\ub7fc \uc4f0\uace0 \uc2f6\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n\n
\ucd1d\ub9e4\ucd9c_\uc798\ubabb = SUM( Sales[\uc218\ub7c9] ) * SUM( Sales[\ub2e8\uac00] )<\/code><\/pre>\n\n
\uacc4\uc0b0\ud574 \ubcf4\uba74 \uc218\ub7c9 \ud569\uacc4 13\uc5d0 \ub2e8\uac00 \ud569\uacc4 248(120 + 4 + 20 + 4 + 100)\uc744 \uacf1\ud558\ub2c8 3,224<\/strong>\uac00 \ub098\uc635\ub2c8\ub2e4. \uc2e4\uc81c \ub9e4\ucd9c\uc740 120 + 12 + 40 + 20 + 200 = 392<\/strong>\uc785\ub2c8\ub2e4. \uc5f4 \uc804\uccb4\ub97c \uba3c\uc800 \ub354\ud55c \ub2e4\uc74c\uc5d0 \uacf1\ud588\uae30 \ub54c\ubb38\uc5d0 \uac12\uc774 \uc804\ud600 \ub2e4\ub985\ub2c8\ub2e4. \ub2e8\uac00\ub294 \ub354\ud558\ub294 \uac12\uc774 \uc544\ub2c8\ub77c\ub294 \uc810\ub3c4 \uac19\uc774 \ubcf4\uc785\ub2c8\ub2e4.<\/p>\n\n
\uc774\ub54c \uc4f0\ub294 \ud568\uc218\uac00 SUMX\uc785\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 \ud55c \uc904\uc529 \ub3cc\uba74\uc11c \uc2dd\uc744 \uacc4\uc0b0\ud558\uace0, \uadf8 \uacb0\uacfc\ub97c \ub354\ud569\ub2c8\ub2e4.<\/p>\n\n
\ucd1d\ub9e4\ucd9c =\nSUMX(\n    Sales,\n    Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00]\n)<\/code><\/pre>\n\n
\uc774\ub807\uac8c \uc4f0\uba74 \ud589\ub9c8\ub2e4 120, 12, 40, 20, 200\uc774 \uacc4\uc0b0\ub418\uc5b4 \ud569\uc774 392\uac00 \ub429\ub2c8\ub2e4. \uc0c1\ud488\ubcc4\ub85c \ub098\ub204\uba74 \ub178\ud2b8\ubd81 320, \ub9c8\uc6b0\uc2a4 32, \ubaa8\ub2c8\ud130 40\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
\uc0c1\ud488<\/th>\ucd1d\uc218\ub7c9<\/th>\ucd1d\ub9e4\ucd9c(SUMX)<\/th><\/tr><\/thead>\n
\ub178\ud2b8\ubd81<\/td>3<\/td>320<\/td><\/tr>\n
\ub9c8\uc6b0\uc2a4<\/td>8<\/td>32<\/td><\/tr>\n
\ubaa8\ub2c8\ud130<\/td>2<\/td>40<\/td><\/tr>\n
\ud569\uacc4<\/td>13<\/td>392<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
\uc815\ub9ac\ud558\uba74 \uae30\uc900\uc740 \ub2e8\uc21c\ud569\ub2c8\ub2e4. \uc5f4 \ud558\ub098\ub97c \uadf8\ub300\ub85c \ub354\ud558\uba74 SUM, \ud589\ub9c8\ub2e4 \uacc4\uc0b0\uc774 \ud544\uc694\ud558\uba74 SUMX<\/strong>\uc785\ub2c8\ub2e4. \uc218\ub7c9 \u00d7 \ub2e8\uac00, \ub9e4\ucd9c \u2212 \ud560\uc778\ucc98\ub7fc \ub450 \uc5f4 \uc774\uc0c1\uc774 \uc5bd\ud788\uac70\ub098 \uc2dd\uc774 \ub4e4\uc5b4\uac00\uba74 SUMX\ub85c \uac00\uc57c \ud569\ub2c8\ub2e4. SUMX\ub294 \uacc4\uc0b0\ud558\ub294 \ub3c4\uc911\uc5d0 \ubcc0\uc218\ub098 \uc784\uc2dc\ub85c \ub9cc\ub4e0 \ud14c\uc774\ube14 \uc704\uc5d0\uc11c\ub3c4 \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
SUM\uc740 \uc0ac\uc2e4 SUMX\uc758 \uc904\uc784\ub9d0<\/h2>\n\n
DAX Guide\uc5d0 \ub530\ub974\uba74 \uc5f4 \ud558\ub098\uc5d0 \uc4f4 SUM\uc740 \ub0b4\ubd80\uc801\uc73c\ub85c SUMX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0, \ub458 \uc0ac\uc774\uc5d0 \uc131\ub2a5 \ucc28\uc774\ub294 \uc5c6\ub2e4\uace0 \ud569\ub2c8\ub2e4. \uc989 \uc544\ub798 \ub450 \uc2dd\uc740 \uac19\uc740 \uacc4\uc0b0\uc785\ub2c8\ub2e4.<\/p>\n\n
SUM( Sales[\uc218\ub7c9] )\nSUMX( Sales, Sales[\uc218\ub7c9] )<\/code><\/pre>\n\n
\uadf8\ub7ec\ub2c8 “SUM\uc774 \ub354 \ube60\ub974\ub2c8\uae4c SUMX\ub294 \ud53c\ud574\uc57c \ud55c\ub2e4”\ub294 \uc2dd\uc73c\ub85c \uc678\uc6b8 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uc5f4 \ud558\ub098\ub97c \ub354\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \uc77d\uae30 \uc26c\uc6b4 SUM\uc744 \uc4f0\uace0, \uc2dd\uc774 \ud544\uc694\ud558\uba74 SUMX\ub97c \uc4f0\uba74 \ub429\ub2c8\ub2e4. \ub2e4\ub9cc SUMX\ub294 \ud589 \ub2e8\uc704\ub85c \ubc18\ubcf5\ud558\ub294 \ud568\uc218\ub77c\uc11c, \ubc18\ubcf5 \uc548\uc5d0 \ubb34\uac70\uc6b4 \uacc4\uc0b0\uc774 \ub4e4\uc5b4\uac00\uba74 \uadf8 \ubd80\ubd84\uc774 \ub290\ub824\uc9c8 \uc218\ub294 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\uacc4\uc0b0 \uc5f4\uc5d0\uc11c SUM\uc744 \uc4f0\uba74 \uc0dd\uae30\ub294 \uc77c<\/h2>\n\n
\uc0c1\ud488 \ud14c\uc774\ube14\uc5d0 “\uc0c1\ud488 \uc218\ub7c9” \uacc4\uc0b0 \uc5f4\uc744 \ub9cc\ub4e4\uba74\uc11c \uc774\ub807\uac8c \uc4f4\ub2e4\uace0 \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\uc0c1\ud488\uc218\ub7c9 = SUM( Sales[\uc218\ub7c9] )<\/code><\/pre>\n\n
\uc0c1\ud488 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uc904\uc5d0 13<\/strong>\uc774 \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \uacc4\uc0b0 \uc5f4\uc5d0\uc11c\ub294 “\ud604\uc7ac \ud589”\uc774\ub77c\ub294 \ud589 \ucee8\ud14d\uc2a4\ud2b8\uac00 \uc0dd\uae30\uc9c0\ub9cc, \ud589 \ucee8\ud14d\uc2a4\ud2b8\ub294 \ub2e4\ub978 \ud14c\uc774\ube14\uc744 \uac78\ub7ec\uc8fc\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc0c1\ud488\ubcc4 \ud569\uacc4\ub97c \uc5bb\uc73c\ub824\uba74 CALCULATE\ub85c \uac10\uc2f8\uc11c \ud604\uc7ac \ud589\uc744 \ud544\ud130\ub85c \ubc14\uafd4 \uc918\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n
\uc0c1\ud488\uc218\ub7c9 = CALCULATE( SUM( Sales[\uc218\ub7c9] ) )<\/code><\/pre>\n\n
\uc0c1\ud488 \ud14c\uc774\ube14\uacfc Sales \uc0ac\uc774\uc5d0 \uad00\uacc4\uac00 \uc788\ub2e4\uba74 \ub178\ud2b8\ubd81 3, \ub9c8\uc6b0\uc2a4 8, \ubaa8\ub2c8\ud130 2\uac00 \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \uc774 \ubd80\ubd84\uc774 \ub9c9\ud788\uba74 CALCULATE \uae00\uc758 “\ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658” \ud56d\ubaa9\uc744 \uac19\uc774 \uc77d\uc5b4 \ubcf4\uc138\uc694.<\/p>\n\n
\uc4f8 \ub54c \uc54c\uc544\ub458 \uc810<\/h2>\n\n
    \n
  • SUM\uc740 \uc5f4 \ud558\ub098\ub9cc \ubc1b\uc2b5\ub2c8\ub2e4. \uc2dd\uc774\ub098 \uc5ec\ub7ec \uc5f4\uc740 SUMX\uc785\ub2c8\ub2e4.<\/li>\n
  • \uc22b\uc790 \uc5f4\uc5d0 \uc4f0\ub294 \ud568\uc218\uc785\ub2c8\ub2e4.<\/li>\n
  • \uac12\uc774 \uc5c6\uc73c\uba74 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12\uc774 \ub098\uc635\ub2c8\ub2e4.<\/li>\n
  • DAX Guide \uae30\uc900\uc73c\ub85c DirectQuery\uc5d0\uc11c\ub3c4 \uce21\uc815\uac12\uacfc \uacc4\uc0b0 \uc5f4\uc5d0 \uc4f8 \uc218 \uc788\uc2b5\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. \ud569\uacc4\ub07c\ub9ac \uacf1\ud558\uae30<\/strong>: \uc704\uc5d0\uc11c \ubcf8 \uac83\ucc98\ub7fc SUM(\uc218\ub7c9) * SUM(\ub2e8\uac00)\ub294 \ub9e4\ucd9c\uc774 \uc544\ub2d9\ub2c8\ub2e4. \ud589 \ub2e8\uc704 \uacc4\uc0b0\uc740 SUMX\uc785\ub2c8\ub2e4.<\/li>\n
    2. \uacc4\uc0b0 \uc5f4\uc5d0 \uadf8\ub0e5 SUM<\/strong>: \ubaa8\ub4e0 \uc904\uc5d0 \uac19\uc740 \uc804\uccb4 \ud569\uacc4\uac00 \ub4e4\uc5b4\uac11\ub2c8\ub2e4.<\/li>\n
    3. \ube48 \uac12\uc744 0\uc73c\ub85c \ucc29\uac01<\/strong>: \ud45c\uc5d0\uc11c \uc904\uc774 \ube44\uc5b4 \ubcf4\uc5ec\ub3c4 \uc624\ub958\uac00 \uc544\ub2d9\ub2c8\ub2e4. \ub370\uc774\ud130\uac00 \uc5c6\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
      \ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n
        \n
      • SUMX<\/strong>: \ud14c\uc774\ube14\uc744 \ud55c \uc904\uc529 \ub3cc\uba70 \uc2dd\uc744 \uacc4\uc0b0\ud574 \ub354\ud569\ub2c8\ub2e4.<\/li>\n
      • AVERAGE, MIN, MAX<\/strong>: \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc5f4 \ud558\ub098\uc758 \ud3c9\uade0, \ucd5c\uc19f\uac12, \ucd5c\ub313\uac12\uc744 \uad6c\ud569\ub2c8\ub2e4.<\/li>\n
      • COUNT, COUNTROWS<\/strong>: \uac12\uc774 \uc788\ub294 \ud589\uc758 \uc218, \ud14c\uc774\ube14\uc758 \ud589 \uc218\ub97c \uc149\ub2c8\ub2e4.<\/li>\n
      • PRODUCT<\/strong>: \uc5f4\uc758 \uc22b\uc790\ub97c \ubaa8\ub450 \uacf1\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
        \uc815\ub9ac<\/h2>\n\n
        SUM\uc740 \uc5f4 \ud558\ub098\ub97c \ub354\ud558\ub294 \uac00\uc7a5 \ub2e8\uc21c\ud55c \uc9d1\uacc4 \ud568\uc218\uc774\uace0, \uc870\uac74\uc774 \ud544\uc694\ud558\uba74 CALCULATE, \ud589\ub9c8\ub2e4 \uacc4\uc0b0\uc774 \ud544\uc694\ud558\uba74 SUMX\ub85c \ub118\uc5b4\uac11\ub2c8\ub2e4. \uc774 \uc138 \uac00\uc9c0\uc758 \uc5ed\ud560\uc744 \uad6c\ubd84\ud574 \ub450\uba74 \uc774\ud6c4\uc5d0 \ub098\uc624\ub294 \ud3c9\uade0, \ube44\uc728, \uc2dc\uac04 \ube44\uad50 \uacc4\uc0b0\ub3c4 \uac19\uc740 \ud2c0 \uc704\uc5d0\uc11c \uc77d\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\uc81c\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc774\ub2c8 \ubcf8\uc778 \ubaa8\ub378\uc758 \uc5f4 \uc774\ub984\uc73c\ub85c \ubc14\uafd4\uc11c \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc2dc\uace0, \ud568\uc218 \ub3d9\uc791\uc740 Power BI \ubc84\uc804\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc73c\ub2c8 \uacf5\uc2dd \ubb38\uc11c\ub3c4 \ud568\uaed8 \ud655\uc778\ud574 \uc8fc\uc138\uc694.<\/p>\n\n
        \ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n
          \n
        • Microsoft Learn, SUM function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/sum-function-dax<\/li>\n
        • Microsoft Learn, Aggregation functions (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/aggregation-functions-dax<\/li>\n
        • DAX Guide, SUM: https:\/\/dax.guide\/sum\/<\/li>\n
        • DAX Guide, SUMX: https:\/\/dax.guide\/sumx\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
          DAX SUM \ud568\uc218\uc758 \ubb38\ubc95\uacfc \ube48 \uac12 \ucc98\ub9ac, SUMX\ub85c \ub118\uc5b4\uac00\ub294 \uae30\uc900, \uacc4\uc0b0 \uc5f4\uc5d0\uc11c \uc0dd\uae30\ub294 \ud568\uc815\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":[4,6,7,8],"class_list":["post-22","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-power-bi","tag-sum","tag-sumx"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/22","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=22"}],"version-history":[{"count":0,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}