{"id":23,"date":"2026-10-01T23:05:21","date_gmt":"2026-10-01T14:05:21","guid":{"rendered":"https:\/\/vera-b.com\/?p=23"},"modified":"2026-10-01T23:05:21","modified_gmt":"2026-10-01T14:05:21","slug":"dax-sumx-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ed%96%89%eb%a7%88%eb%8b%a4-%ea%b3%84%ec%82%b0%ed%95%b4%ec%84%9c-%eb%8d%94%ed%95%a0-%eb%95%8c-%ec%93%b0%eb%8a%94-%eb%b0%98%eb%b3%b5-%ed%95%a8%ec%88%98","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=23","title":{"rendered":"DAX SUMX \ud568\uc218 \uc815\ub9ac: \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud574\uc11c \ub354\ud560 \ub54c \uc4f0\ub294 \ubc18\ubcf5 \ud568\uc218"},"content":{"rendered":"\n

SUM\uc73c\ub85c \uc5f4\uc744 \ub354\ud558\ub2e4 \ubcf4\uba74 \uae08\ubc29 \ubcbd\uc744 \ub9cc\ub0a9\ub2c8\ub2e4. \ub9e4\ucd9c\uc740 \uc218\ub7c9\uc5d0 \ub2e8\uac00\ub97c \uacf1\ud574\uc57c \ub098\uc624\ub294\ub370, \uc6b0\ub9ac \ud45c\uc5d0\ub294 “\ub9e4\ucd9c” \uc5f4\uc774 \uc5c6\ub294 \uacbd\uc6b0\uac00 \ub9ce\uac70\ub4e0\uc694. \uc5f4\uc744 \ud558\ub098 \ub354 \ub9cc\ub4e4\uc5b4 \ub458 \uc218\ub3c4 \uc788\uc9c0\ub9cc, \uce21\uc815\uac12 \uc548\uc5d0\uc11c \ubc14\ub85c \uacc4\uc0b0\ud558\uace0 \uc2f6\uc744 \ub54c \uc4f0\ub294 \ud568\uc218\uac00 SUMX\uc785\ub2c8\ub2e4. \uc774\ub984 \ub05d\uc758 X\ub294 “\ud589\ub9c8\ub2e4 \uc2dd\uc744 \uacc4\uc0b0\ud55c\ub2e4”\ub294 \ub73b\uc73c\ub85c \uc774\ud574\ud558\uba74 \ud3b8\ud569\ub2c8\ub2e4.<\/p>\n\n

SUMX\uac00 \ud558\ub294 \uc77c<\/h2>\n\n
SUMX( <\ud14c\uc774\ube14>, <\uc2dd> )<\/code><\/pre>\n\n
\uccab \ubc88\uc9f8 \uc778\uc218\ub85c \ubc1b\uc740 \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\ud558\uace0, \uacb0\uacfc\ub97c \ubaa8\ub450 \ub354\ud569\ub2c8\ub2e4. \uc774\ub807\uac8c \ud589\uc744 \ud558\ub098\uc529 \ub3c4\ub294 \ud568\uc218\ub97c \ubc18\ubcf5 \ud568\uc218(iterator)<\/strong>\ub77c\uace0 \ubd80\ub985\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \uc18c\uc218 \ud615\ud0dc\uc758 \uc22b\uc790\uc785\ub2c8\ub2e4.<\/p>\n\n
Microsoft \ubb38\uc11c\uc5d0 \ub530\ub974\uba74 \uccab \ubc88\uc9f8 \uc778\uc218\ub294 \ud14c\uc774\ube14 \uc790\uccb4\uc774\uac70\ub098 \ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc8fc\ub294 \uc2dd\uc774\uc5b4\ub3c4 \ub429\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uacc4\uc0b0 \uacb0\uacfc \uc911 \uc22b\uc790\ub9cc \ub354\ud574\uc9c0\uace0, \ube48 \uac12\uacfc \ub17c\ub9ac\uac12(TRUE\/FALSE), \ud14d\uc2a4\ud2b8\ub294 \ubb34\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n\n
\uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
\uc55e\uc120 SUM \ud568\uc218 \uae00<\/a>\uacfc \uac19\uc740 \uac00\uc0c1 \ub370\uc774\ud130\ub97c \uc501\ub2c8\ub2e4. \ub2e8\uac00\ub294 \ub9cc\uc6d0 \ub2e8\uc704\uc774\uace0, \uacb0\uacfc\ub294 Power BI\uc5d0\uc11c \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uc9c1\uc811 \uacc4\uc0b0\ud574\uc11c \uc801\uc740 \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
\uae30\ubcf8: \uc218\ub7c9 \uacf1\ud558\uae30 \ub2e8\uac00<\/h2>\n\n
\ucd1d\ub9e4\ucd9c =\nSUMX(\n    Sales,\n    Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00]\n)<\/code><\/pre>\n\n
\ud589\ub9c8\ub2e4 120, 12, 40, 20, 200\uc774 \uacc4\uc0b0\ub418\uace0 \ud569\uc740 392\uc785\ub2c8\ub2e4. SUM\uc73c\ub85c\ub294 \uc774 \uacc4\uc0b0\uc744 \ud55c \ubc88\uc5d0 \ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. SUM\uc740 \uc5f4 \ud558\ub098\ub9cc \ubc1b\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n
\uc2dd \uc548\uc5d0\uc11c \uc870\uac74\uc744 \uc4f0\uae30<\/h2>\n\n
\ub178\ud2b8\ubd81\ub9cc 10% \ud560\uc778\ud55c \ub9e4\ucd9c\uc744 \ubcf4\uace0 \uc2f6\ub2e4\uace0 \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud589\ub9c8\ub2e4 \uc870\uac74\uc5d0 \ub530\ub77c \uacf1\ud558\ub294 \uac12\uc774 \ub2ec\ub77c\uc9c0\ub2c8 \uc774\uac83\ub3c4 SUMX\uc758 \uc601\uc5ed\uc785\ub2c8\ub2e4.<\/p>\n\n
\ud560\uc778\ud6c4\ub9e4\ucd9c =\nSUMX(\n    Sales,\n    Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00]\n        * IF( Sales[\uc0c1\ud488] = \"\ub178\ud2b8\ubd81\", 0.9, 1 )\n)<\/code><\/pre>\n\n
\ub178\ud2b8\ubd81 \ub450 \uc904(120, 200)\uc740 \uac01\uac01 108, 180\uc774 \ub418\uace0 \ub098\uba38\uc9c0 \uc138 \uc904(12, 40, 20)\uc740 \uadf8\ub300\ub85c\ub77c\uc11c \ud569\uacc4\uac00 360<\/strong>\uc785\ub2c8\ub2e4. \uc6d0\ub798 \ub9e4\ucd9c 392\uc5d0\uc11c \ub178\ud2b8\ubd81 \ub9e4\ucd9c 320\uc758 10%\uc778 32\uac00 \ube60\uc9c4 \uac12\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\ud14c\uc774\ube14 \uc790\uccb4\ub97c \uac78\ub7ec\uc11c \ub118\uae30\uae30<\/h2>\n\n
Microsoft \ubb38\uc11c\uc758 \uc608\uc81c\ucc98\ub7fc \uccab \ubc88\uc9f8 \uc778\uc218\uc5d0 FILTER\ub97c \ub123\uc5b4\uc11c \uc77c\ubd80 \ud589\ub9cc \ub354\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\ub178\ud2b8\ubd81\ub9e4\ucd9c =\nSUMX(\n    FILTER( Sales, Sales[\uc0c1\ud488] = \"\ub178\ud2b8\ubd81\" ),\n    Sales[\uc218\ub7c9] * Sales[\ub2e8\uac00]\n)<\/code><\/pre>\n\n
\uacb0\uacfc\ub294 120 + 200 = 320\uc785\ub2c8\ub2e4. \uac19\uc740 \uac12\uc744 CALCULATE\ub85c\ub3c4 \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\ub178\ud2b8\ubd81\ub9e4\ucd9c =\nCALCULATE( [\ucd1d\ub9e4\ucd9c], Sales[\uc0c1\ud488] = \"\ub178\ud2b8\ubd81\" )<\/code><\/pre>\n\n
\ub450 \ubc29\uc2dd \ubaa8\ub450 320\uc774 \ub098\uc635\ub2c8\ub2e4. \uc5b4\ub290 \ucabd\uc774\ub4e0 \ub418\uc9c0\ub9cc, SQLBI\ub294 \ud14c\uc774\ube14 \uc804\uccb4\ub97c FILTER\ub85c \uac70\ub294 \uac83\ubcf4\ub2e4 \uc5f4 \ud558\ub098\uc5d0 \uc870\uac74\uc744 \uac70\ub294 \ucabd\uc774 \ub354 \uac00\ubccd\uace0 \uc548\uc804\ud558\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \ud544\ud130\ub9c1\uc774 \ubaa9\uc801\uc774\ub77c\uba74 CALCULATE \ucabd\uc744 \uba3c\uc800 \uace0\ub824\ud574 \ubcfc \ub9cc\ud569\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 CALCULATE \ud568\uc218 \uae00<\/a>\uc5d0 \uc801\uc5b4 \ub450\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\uce21\uc815\uac12\uc744 \ud589\ub9c8\ub2e4 \ud3c9\uac00\ud558\ub294 \ud328\ud134<\/h2>\n\n
SUMX\ub294 \ud14c\uc774\ube14\ubfd0 \uc544\ub2c8\ub77c “\uc0c1\ud488 \ubaa9\ub85d” \uac19\uc740 \uac12 \ubaa9\ub85d \uc704\uc5d0\uc11c\ub3c4 \ub9ce\uc774 \ub3cc\ub9bd\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc0c1\ud488\ubcc4 \ub9e4\ucd9c \uc911 100\uc744 \ub118\ub294 \uc0c1\ud488\ub9cc \ud569\uce58\uace0 \uc2f6\ub2e4\uba74 \uc774\ub807\uac8c \uc501\ub2c8\ub2e4.<\/p>\n\n
\ud070\uc0c1\ud488\ub9e4\ucd9c =\nSUMX(\n    VALUES( Sales[\uc0c1\ud488] ),\n    IF( [\ucd1d\ub9e4\ucd9c] > 100, [\ucd1d\ub9e4\ucd9c] )\n)<\/code><\/pre>\n\n
VALUES\uac00 \ud604\uc7ac \ud544\ud130 \uc0c1\ud0dc\uc758 \uc0c1\ud488 \ubaa9\ub85d(\ub178\ud2b8\ubd81, \ub9c8\uc6b0\uc2a4, \ubaa8\ub2c8\ud130)\uc744 \ub3cc\ub824\uc8fc\uace0, SUMX\uac00 \uadf8 \uc0c1\ud488\uc744 \ud558\ub098\uc529 \ub3cc\uba74\uc11c [\ucd1d\ub9e4\ucd9c]<\/code>\uc744 \uacc4\uc0b0\ud569\ub2c8\ub2e4. \uc0c1\ud488\ubcc4 \ub9e4\ucd9c\uc740 \ub178\ud2b8\ubd81 320, \ub9c8\uc6b0\uc2a4 32, \ubaa8\ub2c8\ud130 40\uc774\ub2c8 100\uc744 \ub118\ub294 \uac83\uc740 \ub178\ud2b8\ubd81\ubfd0\uc774\ub77c \uacb0\uacfc\ub294 320<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n
\uc5ec\uae30\uc11c \ub208\uc5ec\uaca8\ubcfc \uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ubcf5 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc744 \uc4f0\uba74 “\uc9c0\uae08 \ub3c4\ub294 \ud589\uc758 \uc0c1\ud488”\uc774 \uc790\ub3d9\uc73c\ub85c \ud544\ud130\ub85c \ubc14\ub00c\uc5b4\uc11c \uadf8 \uc0c1\ud488\uc758 \ub9e4\ucd9c\uc774 \uacc4\uc0b0\ub429\ub2c8\ub2e4. \uc774\uac83\uc774 \ud589 \ucee8\ud14d\uc2a4\ud2b8\uac00 \ud544\ud130 \ucee8\ud14d\uc2a4\ud2b8\ub85c \ubc14\ub00c\ub294 \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658<\/strong>\uc785\ub2c8\ub2e4. \uce21\uc815\uac12 \ucc38\uc870\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c CALCULATE\ub97c \uac10\uc2f8\ub294 \uac83\uacfc \uac19\ub2e4\uace0 SQLBI\uc640 Microsoft \ubb38\uc11c\uac00 \uc124\uba85\ud569\ub2c8\ub2e4. DAX Guide\uc758 SUMX \ud398\uc774\uc9c0\uc5d0\ub3c4, \ud589 \ucee8\ud14d\uc2a4\ud2b8 \uc548\uc5d0\uc11c \ud638\ucd9c\ub418\uba74 \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub09c\ub2e4\ub294 \uc124\uba85\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
\ubcc0\uc218\ub97c \ub3cc\ub9b4 \ub54c\ub3c4 SUMX<\/h2>\n\n
DAX Guide\ub294 SUMX\uac00 \ud544\uc694\ud55c \uc0c1\ud669\uc73c\ub85c “\ubcc0\uc218\uc5d0 \ub2f4\uae34 \ud14c\uc774\ube14\uc744 \ubc18\ubcf5\ud560 \ub54c”\ub97c \ub530\ub85c \uaf3d\uc2b5\ub2c8\ub2e4. SUM\uc740 \ubaa8\ub378\uc5d0 \uc788\ub294 \uc5f4\ub9cc \ubc1b\uae30 \ub54c\ubb38\uc5d0, VAR\ub85c \ub9cc\ub4e0 \uc784\uc2dc \ud14c\uc774\ube14\uc758 \uc5f4\uc740 \ub354\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub7f4 \ub54c SUMX\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n
SUM\uacfc\uc758 \uad00\uacc4<\/h2>\n\n
DAX Guide\uc5d0\ub294 “SUM\uc740 \uc5f4 \ud558\ub098\uc5d0 \uc4f4 SUMX\uc758 \uc904\uc784 \ud45c\ud604”\uc774\ub77c\uace0 \uc801\ud600 \uc788\uace0, \ub458 \uc0ac\uc774\uc5d0 \uc131\ub2a5 \ucc28\uc774\ub294 \uc5c6\ub2e4\uace0 \ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub2c8 \uc774\ub807\uac8c \uc815\ub9ac\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n
    \n
  • \uc5f4 \ud558\ub098\ub97c \uadf8\ub300\ub85c \ub354\ud55c\ub2e4 \u2192 SUM<\/li>\n
  • \ud589\ub9c8\ub2e4 \uc2dd\uc744 \uacc4\uc0b0\ud574\uc11c \ub354\ud55c\ub2e4 \u2192 SUMX<\/li>\n<\/ul>\n\n
    Microsoft \ubb38\uc11c\ub3c4 \ub9c8\uc9c0\ub9c9\uc5d0 “\uc5f4\uc744 \uac78\ub7ec\ub0bc \ud544\uc694\uac00 \uc5c6\ub2e4\uba74 SUM\uc744 \uc4f0\ub77c”\uace0 \ub367\ubd99\uc785\ub2c8\ub2e4.<\/p>\n\n
    \uc4f8 \ub54c \uc8fc\uc758\ud560 \uc810<\/h2>\n\n
      \n
    • SUMX\ub294 \ud589\uc744 \ud558\ub098\uc529 \ub3c4\ub294 \ud568\uc218\ub77c\uc11c, \ubc18\ubcf5\ud558\ub294 \uc2dd\uc774 \ubb34\uac70\uc6b0\uba74 \uadf8\ub9cc\ud07c \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ubcf5 \uc548\uc5d0 \ub610 \ubc18\ubcf5\uc744 \ub123\ub294 \uc911\ucca9\uc740 \ud2b9\ud788 \uc870\uc2ec\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774\ub7f0 \ube44\uc6a9\uc744 \uc904\uc774\ub294 \ucd5c\uc801\ud654 \uae30\ubc95\uc774 \uc788\ub2e4\uace0 DAX Guide\uac00 \uad00\ub828 \uae00\uc744 \uc548\ub0b4\ud569\ub2c8\ub2e4.<\/li>\n
    • \ud569\uc0b0\ub418\ub294 \uac83\uc740 \uc22b\uc790\ubfd0\uc785\ub2c8\ub2e4. \uc2dd\uc758 \uacb0\uacfc\uac00 \ube48 \uac12, \ub17c\ub9ac\uac12, \ud14d\uc2a4\ud2b8\uc774\uba74 \ubb34\uc2dc\ub429\ub2c8\ub2e4.<\/li>\n
    • DirectQuery \ubaa8\ub4dc\uc5d0\uc11c\ub294 \uacc4\uc0b0 \uc5f4\uc774\ub098 \ud589 \uc218\uc900 \ubcf4\uc548 \uaddc\uce59 \uc548\uc5d0\uc11c \uc4f8 \uc218 \uc5c6\ub2e4\uace0 Microsoft \ubb38\uc11c\uc5d0 \uc801\ud600 \uc788\uc2b5\ub2c8\ub2e4. \uce21\uc815\uac12\uc5d0\uc11c\ub294 \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
    • \uccab \ubc88\uc9f8 \uc778\uc218\ub294 “\ub354\ud560 \ud589\uc774 \ub2f4\uae34 \ud14c\uc774\ube14”\uc785\ub2c8\ub2e4. \uc5f4\uc774 \uc544\ub2c8\ub77c \ud14c\uc774\ube14\uc744 \ub123\ub294\ub2e4\ub294 \uc810\uc744 \ud5f7\uac08\ub9ac\uae30 \uc27d\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
      \uc790\uc8fc \ud558\ub294 \uc2e4\uc218<\/h2>\n\n
        \n
      1. SUM\uc73c\ub85c \uacf1\uc148 \ud569\uacc4\ub97c \uad6c\ud558\ub824\ub294 \uacbd\uc6b0<\/strong>: SUM(\uc218\ub7c9) \u00d7 SUM(\ub2e8\uac00)\ub294 3,224\uac00 \ub098\uc635\ub2c8\ub2e4. \ud589\ub9c8\ub2e4 \uacf1\ud558\ub294 SUMX\ub294 392\uc785\ub2c8\ub2e4.<\/li>\n
      2. \uccab \uc778\uc218\uc5d0 \uc5f4\uc744 \ub123\ub294 \uacbd\uc6b0<\/strong>: SUMX( Sales[\uc218\ub7c9], … )\ucc98\ub7fc \uc4f0\uba74 \uc548 \ub429\ub2c8\ub2e4. \ud14c\uc774\ube14\uc774 \uc640\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
      3. \ubc18\ubcf5 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc774 \uc608\uc0c1\uacfc \ub2e4\ub978 \uacbd\uc6b0<\/strong>: \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub098\ub294 \uac83\uc774 \uc815\uc0c1 \ub3d9\uc791\uc778\uc9c0 \uba3c\uc800 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/li>\n<\/ol>\n\n
        \ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n
          \n
        • SUM<\/strong>: \uc5f4 \ud558\ub098\uc758 \ud569\uacc4<\/li>\n
        • AVERAGEX, MINX, MAXX, COUNTX<\/strong>: \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \ub4a4 \ud3c9\uade0, \ucd5c\uc18c, \ucd5c\ub300, \uac1c\uc218\ub97c \uad6c\ud558\ub294 \ubc18\ubcf5 \ud568\uc218<\/li>\n
        • CALCULATE<\/strong>: \ubc18\ubcf5\uc774 \uc544\ub2c8\ub77c \ud544\ud130\ub97c \ubc14\uafd4\uc11c \uacc4\uc0b0\ud558\ub294 \ud568\uc218<\/li>\n<\/ul>\n\n
          \uc815\ub9ac<\/h2>\n\n
          SUMX\ub294 “\ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud558\uace0 \ub354\ud55c\ub2e4”\ub294 \ud55c \ubb38\uc7a5\uc73c\ub85c \uc694\uc57d\ub429\ub2c8\ub2e4. \uacf1\uc148\uc774\ub098 \uc870\uac74\uc774 \uc11e\uc778 \ud569\uacc4\ub294 SUMX, \ub2e8\uc21c \ud569\uacc4\ub294 SUM, \uc870\uac74\ub9cc \ubc14\uafb8\uace0 \uc2f6\ub2e4\uba74 CALCULATE\ub85c \uad6c\ubd84\ud574 \ub450\uba74 \uc774\ud6c4 \ud568\uc218\ub4e4\ub3c4 \ud6e8\uc52c \uc218\uc6d4\ud569\ub2c8\ub2e4. \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, SUMX function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/sumx-function-dax<\/li>\n
          • DAX Guide, SUMX: https:\/\/dax.guide\/sumx\/<\/li>\n
          • SQLBI, Context transition in DAX explained visually: https:\/\/www.sqlbi.com\/articles\/context-transition-in-dax-explained-visually\/<\/li>\n
          • SQLBI, Introducing CALCULATE in DAX: https:\/\/www.sqlbi.com\/articles\/introducing-calculate-in-dax\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
            DAX SUMX \ud568\uc218\uc758 \ubb38\ubc95, \uc870\uac74\uacfc FILTER \uc0ac\uc6a9, \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658, SUM\uacfc\uc758 \uad00\uacc4\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,6,8],"class_list":["post-23","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-power-bi","tag-sumx"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/23","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=23"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":26,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions\/26"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}