{"id":19,"date":"2026-10-01T22:46:02","date_gmt":"2026-10-01T13:46:02","guid":{"rendered":"https:\/\/vera-b.com\/?p=19"},"modified":"2026-10-01T22:46:02","modified_gmt":"2026-10-01T13:46:02","slug":"dax-calculate-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ed%95%84%ed%84%b0%eb%a5%bc-%eb%b0%94%ea%bf%94%ec%84%9c-%ea%b3%84%ec%82%b0%ed%95%9c%eb%8b%a4%eb%8a%94-%ea%b2%8c-%eb%ac%b4%ec%8a%a8-%eb%9c%bb","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=19","title":{"rendered":"DAX CALCULATE \ud568\uc218 \uc815\ub9ac: \ud544\ud130\ub97c \ubc14\uafd4\uc11c \uacc4\uc0b0\ud55c\ub2e4\ub294 \uac8c \ubb34\uc2a8 \ub73b\uc77c\uae4c"},"content":{"rendered":"\n

\uce21\uc815\uac12 \ud558\ub098 \ub9cc\ub4e4\uc5b4\uc11c \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc9c0\uc5ed\ubcc4 \ud569\uacc4\uac00 \uc54c\uc544\uc11c \ub098\ub258\uc5b4 \ub098\uc635\ub2c8\ub2e4. \uc5ec\uae30\uae4c\uc9c0\ub294 SUM \ud558\ub098\ub85c \ub05d\ub0a9\ub2c8\ub2e4. \uadf8\ub7f0\ub370 “\uc11c\uc6b8 \ub9e4\ucd9c\ub9cc \ub530\ub85c \ubcf4\uace0 \uc2f6\ub2e4”, “\uc804\uccb4\uc5d0\uc11c \uc774 \uc9c0\uc5ed\uc774 \ucc28\uc9c0\ud558\ub294 \ube44\uc911\uc744 \uc54c\uace0 \uc2f6\ub2e4” \uac19\uc740 \uc694\uad6c\uac00 \ub098\uc624\uba74 SUM\ub9cc\uc73c\ub85c\ub294 \uc548 \ub429\ub2c8\ub2e4. \uc774\ub54c \ucc98\uc74c \ub9cc\ub098\ub294 \ud568\uc218\uac00 CALCULATE\uc785\ub2c8\ub2e4.<\/p>\n\n

CALCULATE\ub294 DAX\uc5d0\uc11c \uac00\uc7a5 \uc911\uc694\ud55c \ud568\uc218\ub85c \uc790\uc8fc \uaf3d\ud788\uace0, \ub3d9\uc2dc\uc5d0 \uc785\ubb38\uc790\uac00 \uac00\uc7a5 \uc624\ub798 \ubd99\uc7a1\uace0 \uc788\ub294 \ud568\uc218\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4. \ubb38\ubc95 \uc790\uccb4\ub294 \uc9e7\uc740\ub370 \ub3d9\uc791 \uaddc\uce59\uc774 \uba87 \uac00\uc9c0 \uc228\uc5b4 \uc788\uc5b4\uc11c \uadf8\ub807\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \ubb38\ubc95\ubd80\ud130 \ud544\ud130 \ub36e\uc5b4\uc4f0\uae30, KEEPFILTERS, \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uae4c\uc9c0 \ud55c \ubc88\uc5d0 \uc815\ub9ac\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n

\ud55c \uc904\ub85c \ub9d0\ud558\uba74<\/h2>\n\n

CALCULATE\ub294 \ud544\ud130 \uc870\uac74\uc744 \ubc14\uafbc \uc0c1\ud0dc\uc5d0\uc11c \uc2dd\uc744 \ub2e4\uc2dc \uacc4\uc0b0<\/strong>\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc758 \uc124\uba85\ub3c4 “\uc218\uc815\ub41c \ud544\ud130 \ucee8\ud14d\uc2a4\ud2b8\uc5d0\uc11c \uc2dd\uc744 \ud3c9\uac00\ud55c\ub2e4”\ub294 \ucde8\uc9c0\uc785\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc758 \uac01 \uc140\uc5d0\ub294 \uc774\ubbf8 \uc2ac\ub77c\uc774\uc11c, \ud589 \uba38\ub9ac\uae00, \ud398\uc774\uc9c0 \ud544\ud130\uac00 \ub9cc\ub4e0 “\ud604\uc7ac \ud544\ud130 \uc0c1\ud0dc”\uac00 \uac78\ub824 \uc788\ub294\ub370, CALCULATE\ub294 \uadf8 \uc0c1\ud0dc\ub97c \uc7a0\uae50 \uace0\uccd0\uc11c \uacc4\uc0b0\ud55c \uacb0\uacfc\ub97c \ub3cc\ub824\uc90d\ub2c8\ub2e4.<\/p>\n\n

\ubb38\ubc95\uacfc \uc778\uc218<\/h2>\n\n
CALCULATE( <\uc2dd> [, <\ud544\ud1301> [, <\ud544\ud1302> [, ...]]] )<\/code><\/pre>\n\n
    \n
  • \uccab \ubc88\uc9f8 \uc778\uc218(\uc2dd)<\/strong>: \uacc4\uc0b0\ud560 \ub300\uc0c1\uc785\ub2c8\ub2e4. \uce21\uc815\uac12\ucc98\ub7fc \ub3d9\uc791\ud558\ub294 \uc2dd\uc774\uba74 \ub429\ub2c8\ub2e4. \ubcf4\ud1b5 SUM\uc774\ub098 \uc774\ubbf8 \ub9cc\ub4e4\uc5b4 \ub454 \uce21\uc815\uac12\uc744 \ub123\uc2b5\ub2c8\ub2e4.<\/li>\n
  • \ub450 \ubc88\uc9f8 \uc778\uc218\ubd80\ud130(\ud544\ud130)<\/strong>: \uc0dd\ub7b5\ud574\ub3c4 \ub418\uace0, \uc5ec\ub7ec \uac1c \ub123\uc5b4\ub3c4 \ub429\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \ud544\ud130\ub97c \ubc14\uafbc \uc0c1\ud0dc\uc5d0\uc11c \uacc4\uc0b0\ud55c \uc2dd\uc758 \uacb0\uacfc\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
    \ud544\ud130 \uc790\ub9ac\uc5d0\ub294 \uc138 \uc885\ub958\uac00 \ub4e4\uc5b4\uac11\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc885\ub958<\/th>\uc124\uba85<\/th>\ubaa8\uc591<\/th><\/tr><\/thead>\n
    \ucc38\/\uac70\uc9d3 \uc870\uac74<\/td>\uc5f4 \uac12\uc5d0 \uc870\uac74\uc744 \uac70\ub294 \uac00\uc7a5 \ud754\ud55c \ud615\ud0dc<\/td>Sales[\uc9c0\uc5ed] = “\uc11c\uc6b8”<\/td><\/tr>\n
    \ud14c\uc774\ube14 \ud544\ud130<\/td>\ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc8fc\ub294 \uc2dd. FILTER \ud568\uc218 \ub4f1\uc744 \uc500<\/td>FILTER( … )<\/td><\/tr>\n
    \ud544\ud130 \uc218\uc815 \ud568\uc218<\/td>\uae30\uc874 \ud544\ud130\ub97c \uc9c0\uc6b0\uac70\ub098, \uc720\uc9c0\ud558\uac70\ub098, \uad00\uacc4\ub97c \ubc14\uafc8<\/td>REMOVEFILTERS, KEEPFILTERS, USERELATIONSHIP \ub4f1<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
    \uc544\ub798 \uc608\uc81c\ub294 \uc804\ubd80 \uc774 \uc791\uc740 \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, \uae08\uc561 \ub2e8\uc704\ub294 \ub9cc\uc6d0\uc785\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub4a4\uc5d0 \ub098\uc624\ub294 \uacb0\uacfc \ud45c\ub294 Power BI\uc5d0\uc11c \uc9c1\uc811 \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uacc4\uc0b0 \uc6d0\ub9ac\ub97c \ub530\ub77c\uac00\uba70 \uc190\uc73c\ub85c \uad6c\ud55c \uac12\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc8fc\ubb38\ubc88\ud638<\/th>\uc9c0\uc5ed<\/th>\uc0c1\ud488<\/th>\uae08\uc561<\/th><\/tr><\/thead>\n
    1<\/td>\uc11c\uc6b8<\/td>\ub178\ud2b8\ubd81<\/td>120<\/td><\/tr>\n
    2<\/td>\uc11c\uc6b8<\/td>\ub9c8\uc6b0\uc2a4<\/td>10<\/td><\/tr>\n
    3<\/td>\uc11c\uc6b8<\/td>\ubaa8\ub2c8\ud130<\/td>40<\/td><\/tr>\n
    4<\/td>\ubd80\uc0b0<\/td>\ub178\ud2b8\ubd81<\/td>100<\/td><\/tr>\n
    5<\/td>\ubd80\uc0b0<\/td>\ub9c8\uc6b0\uc2a4<\/td>20<\/td><\/tr>\n
    6<\/td>\ub300\uad6c<\/td>\ubaa8\ub2c8\ud130<\/td>30<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ucd1d\ud569\uc740 320, \uc9c0\uc5ed\ubcc4\ub85c\ub294 \uc11c\uc6b8 170, \ubd80\uc0b0 120, \ub300\uad6c 30\uc785\ub2c8\ub2e4. \uae30\ubcf8 \uce21\uc815\uac12\uc740 \uc774\ub807\uac8c \uc7a1\uc544 \ub450\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ucd1d\ub9e4\ucd9c = SUM( Sales[\uae08\uc561] )<\/code><\/pre>\n\n
    \uc608\uc81c 1. \uc870\uac74 \ud558\ub098 \uac78\uae30<\/h2>\n\n
    \uc11c\uc6b8\ub9e4\ucd9c =\nCALCULATE(\n    [\ucd1d\ub9e4\ucd9c],\n    Sales[\uc9c0\uc5ed] = \"\uc11c\uc6b8\"\n)<\/code><\/pre>\n\n
    “\uc9c0\uc5ed\uc774 \uc11c\uc6b8\uc778 \uc0c1\ud0dc\uc5d0\uc11c \ucd1d\ub9e4\ucd9c\uc744 \uacc4\uc0b0\ud574\ub77c”\ub77c\ub294 \ub73b\uc785\ub2c8\ub2e4. \uc774 \uce21\uc815\uac12\uc744 \uc9c0\uc5ed\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uacb0\uacfc\uac00 \uc774\ub807\uac8c \ub098\uc635\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc9c0\uc5ed<\/th>\ucd1d\ub9e4\ucd9c<\/th>\uc11c\uc6b8\ub9e4\ucd9c<\/th><\/tr><\/thead>\n
    \uc11c\uc6b8<\/td>170<\/td>170<\/td><\/tr>\n
    \ubd80\uc0b0<\/td>120<\/td>170<\/td><\/tr>\n
    \ub300\uad6c<\/td>30<\/td>170<\/td><\/tr>\n
    \ud569\uacc4<\/td>320<\/td>170<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ubd80\uc0b0 \uc904\uc5d0 170\uc774 \ub098\uc624\ub294 \uac8c \uc774\uc0c1\ud574 \ubcf4\uc785\ub2c8\ub2e4. \uc624\ub958\uac00 \uc544\ub2c8\ub77c CALCULATE\uc758 \uae30\ubcf8 \ub3d9\uc791\uc785\ub2c8\ub2e4. \ubc14\ub85c \ub2e4\uc74c \ud56d\ubaa9\uc5d0\uc11c \uc774\uc720\ub97c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uac19\uc740 \uc5f4\uc758 \ud544\ud130\ub294 \ub36e\uc5b4\uc4f4\ub2e4<\/h2>\n\n
    \ubd80\uc0b0 \uc904\uc5d0\ub294 \uc6d0\ub798 “\uc9c0\uc5ed = \ubd80\uc0b0”\uc774\ub77c\ub294 \ud544\ud130\uac00 \uac78\ub824 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0\ub370 CALCULATE \uc548\uc5d0 \uac19\uc740 \uc5f4(\uc9c0\uc5ed)\uc5d0 \ub300\ud55c \ud544\ud130\uac00 \ub4e4\uc5b4\uc624\uba74, \uae30\uc874 \ud544\ud130\ub294 \ud569\uccd0\uc9c0\uc9c0 \uc54a\uace0 \uad50\uccb4<\/strong>\ub429\ub2c8\ub2e4. \uadf8\ub798\uc11c \ubd80\uc0b0 \uc904\uc5d0\uc11c\ub3c4 \uc11c\uc6b8 \uae30\uc900\uc73c\ub85c \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/p>\n\n
    \uc774\uc720\ub294 \ub0b4\ubd80 \ubcc0\ud658\uc5d0 \uc788\uc2b5\ub2c8\ub2e4. DAX Guide\uc640 SQLBI \ubaa8\ub450 \uc124\uba85\ud558\ub294 \ub0b4\uc6a9\uc778\ub370, Sales[\uc9c0\uc5ed] = \"\uc11c\uc6b8\"<\/code> \uac19\uc740 \uc870\uac74\uc740 \uc5d4\uc9c4\uc774 \ub0b4\ubd80\uc801\uc73c\ub85c \uc544\ub798\ucc98\ub7fc \ubc14\uafd4\uc11c \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n
    FILTER( ALL( Sales[\uc9c0\uc5ed] ), Sales[\uc9c0\uc5ed] = \"\uc11c\uc6b8\" )<\/code><\/pre>\n\n
    ALL\uc774 \uc9c0\uc5ed \uc5f4\uc758 \uae30\uc874 \ud544\ud130\ub97c \uba3c\uc800 \uac77\uc5b4\ub0b4\uae30 \ub54c\ubb38\uc5d0, \ubc14\uae65\uc5d0\uc11c \uac78\ub9b0 \ud544\ud130\uac00 \uc0ac\ub77c\uc9c0\ub294 \uac83\uc785\ub2c8\ub2e4. \ud55c \uac00\uc9c0 \ub354, \ud544\ud130 \uc778\uc218\ub294 CALCULATE\uac00 \ucee8\ud14d\uc2a4\ud2b8\ub97c \ubc14\uafb8\uae30 \uc804\uc5d0<\/em>, \uc989 \ubc14\uae65\uc758 \uc6d0\ub798 \ucee8\ud14d\uc2a4\ud2b8\uc5d0\uc11c \uba3c\uc800 \uacc4\uc0b0\ub429\ub2c8\ub2e4. \uc774 \uc21c\uc11c \ub54c\ubb38\uc5d0 \uc774\ubbf8 \ud544\ud130\uac00 \uac78\ub9b0 \uc5f4\uc744 \ub2e4\ub8f0 \ub54c \uacb0\uacfc\uac00 \uc608\uc0c1\uacfc \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc608\uc81c 2. \uc870\uac74\uc744 \uc5ec\ub7ec \uac1c \uac78 \ub54c<\/h2>\n\n
    \uc11c\uc6b8 \ub178\ud2b8\ubd81 =\nCALCULATE(\n    [\ucd1d\ub9e4\ucd9c],\n    Sales[\uc9c0\uc5ed] = \"\uc11c\uc6b8\",\n    Sales[\uc0c1\ud488] = \"\ub178\ud2b8\ubd81\"\n)<\/code><\/pre>\n\n
    \ud544\ud130 \uc778\uc218\ub97c \uc5ec\ub7ec \uac1c \ub098\uc5f4\ud558\uba74 \ubaa8\ub450 \ub9cc\uc871\ud574\uc57c \ud558\ub294 AND \uc870\uac74\uc73c\ub85c \ubb36\uc785\ub2c8\ub2e4. \uc11c\uc6b8\uc774\uba74\uc11c \ub178\ud2b8\ubd81\uc778 \ud589\uc740 1\ubc88 \uc8fc\ubb38 \ud558\ub098\ub77c 120\uc785\ub2c8\ub2e4. \uc704 \ub36e\uc5b4\uc4f0\uae30 \uaddc\uce59 \ub54c\ubb38\uc5d0 \uc9c0\uc5ed\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \ubaa8\ub4e0 \uc904\uc5d0 120\uc774 \ucc0d\ud799\ub2c8\ub2e4.<\/p>\n\n
    OR \uc870\uac74\uc774 \ud544\uc694\ud558\uba74 \ud55c \uc870\uac74\uc2dd \uc548\uc5d0\uc11c ||<\/code>\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n
    \uc11c\uc6b8 \ub610\ub294 \ub300\uad6c =\nCALCULATE(\n    [\ucd1d\ub9e4\ucd9c],\n    Sales[\uc9c0\uc5ed] = \"\uc11c\uc6b8\" || Sales[\uc9c0\uc5ed] = \"\ub300\uad6c\"\n)<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 170 + 30 = 200\uc785\ub2c8\ub2e4. \ub2e4\ub9cc \ud558\ub098\uc758 \uc870\uac74\uc2dd \uc548\uc5d0 \uc4f8 \uc218 \uc788\ub294 \uc5f4\uc740 \uac19\uc740 \ud14c\uc774\ube14\uc758 \uc5f4<\/strong>\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 Sales\uc758 \uc218\ub7c9 \uc870\uac74\uacfc Product\uc758 \uc0c9\uc0c1 \uc870\uac74\uc744 ||<\/code>\ub85c \ubb36\ub294 \uc2dd\uc740 \ud5c8\uc6a9\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub7f0 \uacbd\uc6b0\ub294 \ub2e4\ub978 \ubc29\uc2dd(\ud14c\uc774\ube14 \ud544\ud130 \ub4f1)\uc73c\ub85c \ud480\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n
    AND \uc870\uac74\uc740 &&<\/code>\ub85c \ud55c \uc2dd\uc5d0 \ubb36\uc744 \uc218\ub3c4 \uc788\uc9c0\ub9cc, SQLBI\ub294 \uc131\ub2a5 \uba74\uc5d0\uc11c \uc778\uc218\ub97c \ub530\ub85c \ub098\ub220 \uc4f0\uae30\ub97c \uad8c\ud569\ub2c8\ub2e4. \uac19\uc740 \ud6a8\uacfc\uc774\ub2c8 \ub098\ub220 \uc4f0\ub294 \ucabd\uc774 \ub0ab\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc608\uc81c 3. \uc804\uccb4 \ub300\ube44 \ube44\uc911<\/h2>\n\n
    \uc9c0\uc5ed\ube44\uc911 =\nDIVIDE(\n    [\ucd1d\ub9e4\ucd9c],\n    CALCULATE( [\ucd1d\ub9e4\ucd9c], REMOVEFILTERS( Sales[\uc9c0\uc5ed] ) )\n)<\/code><\/pre>\n\n
    \ubd84\ubaa8 \ucabd CALCULATE\uac00 \uc9c0\uc5ed \ud544\ud130\ub97c \ubaa8\ub450 \uac77\uc5b4\ub0b4\uc11c \uc804\uccb4 \ud569\uacc4 320\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. \ubd84\uc790\ub294 \ud604\uc7ac \uc904\uc758 \uac12\uc774\uace0\uc694. DIVIDE\ub294 \ubd84\ubaa8\uac00 0\uc774\uac70\ub098 \ube44\uc5b4 \uc788\uc744 \ub54c \uc624\ub958 \ub300\uc2e0 \ube48 \uac12\uc744 \ub3cc\ub824\uc8fc\ub294 \ub098\ub217\uc148 \ud568\uc218\ub77c\uc11c \ube44\uc728 \uacc4\uc0b0\uc5d0 \ub9ce\uc774 \uc501\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc9c0\uc5ed<\/th>\ucd1d\ub9e4\ucd9c<\/th>\uc9c0\uc5ed\ube44\uc911<\/th><\/tr><\/thead>\n
    \uc11c\uc6b8<\/td>170<\/td>53.1%<\/td><\/tr>\n
    \ubd80\uc0b0<\/td>120<\/td>37.5%<\/td><\/tr>\n
    \ub300\uad6c<\/td>30<\/td>9.4%<\/td><\/tr>\n
    \ud569\uacc4<\/td>320<\/td>100.0%<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ud544\ud130\ub97c \uc9c0\uc6b0\ub294 \ud568\uc218\ub85c ALL\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc ALL\uc740 \ud544\ud130\ub97c \uc9c0\uc6b0\ub294 \uc5ed\ud560\uacfc \ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc8fc\ub294 \uc5ed\ud560\uc744 \uacb8\ud558\ub294 \ud568\uc218\ub77c\uc11c, \ud544\ud130\ub97c \uc9c0\uc6b0\ub294 \ubaa9\uc801\uc774\ub77c\uba74 REMOVEFILTERS\uac00 \uc758\ub3c4\ub97c \ub354 \ubd84\uba85\ud558\uac8c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. Microsoft \ubb38\uc11c\ub3c4 REMOVEFILTERS\ub97c \uc4f8 \uc218 \uc788\ub294 \ud658\uacbd\uc774\ub77c\uba74 \uadf8\ucabd\uc744 \uad8c\ud558\ub294 \ucde8\uc9c0\ub85c \uc801\uc5b4 \ub450\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ub36e\uc5b4\uc4f0\uc9c0 \uc54a\uace0 \uacb9\uce58\uace0 \uc2f6\uc744 \ub54c: KEEPFILTERS<\/h2>\n\n
    \uc11c\uc6b8\ub9e4\ucd9c_\uad50\ucc28 =\nCALCULATE(\n    [\ucd1d\ub9e4\ucd9c],\n    KEEPFILTERS( Sales[\uc9c0\uc5ed] = \"\uc11c\uc6b8\" )\n)<\/code><\/pre>\n\n
    KEEPFILTERS\ub85c \uac10\uc2f8\uba74 \uae30\uc874 \ud544\ud130\ub97c \uc9c0\uc6b0\uc9c0 \uc54a\uace0 \uc0c8 \ud544\ud130\uc640 \uad50\uc9d1\ud569<\/strong>\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. \uc11c\uc6b8 \uc904\uc740 “\uc11c\uc6b8\uc774\uba74\uc11c \uc11c\uc6b8”\uc774\ub77c 170, \ubd80\uc0b0 \uc904\uc740 “\ubd80\uc0b0\uc774\uba74\uc11c \uc11c\uc6b8”\uc774\ub77c \ud574\ub2f9 \ud589\uc774 \uc5c6\uc5b4 \ube48 \uac12\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n
    \uc9c0\uc5ed<\/th>\uc11c\uc6b8\ub9e4\ucd9c(\ub36e\uc5b4\uc4f0\uae30)<\/th>\uc11c\uc6b8\ub9e4\ucd9c_\uad50\ucc28(KEEPFILTERS)<\/th><\/tr><\/thead>\n
    \uc11c\uc6b8<\/td>170<\/td>170<\/td><\/tr>\n
    \ubd80\uc0b0<\/td>170<\/td>(\ube48 \uac12)<\/td><\/tr>\n
    \ub300\uad6c<\/td>170<\/td>(\ube48 \uac12)<\/td><\/tr>\n
    \ud569\uacc4<\/td>170<\/td>170<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    CALCULATE\uac00 \uc2e4\uc81c\ub85c \uc77c\ud558\ub294 \uc21c\uc11c<\/h2>\n\n
    DAX Guide\uc5d0\ub294 \ud3c9\uac00 \uc21c\uc11c\uac00 \uc815\ub9ac\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub300\ub85c \uc62e\uae30\uc9c0 \uc54a\uace0 \ud750\ub984\ub9cc \ud480\uc5b4 \uc4f0\uba74 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n
      \n
    1. \ud544\ud130 \uc778\uc218\ub4e4\uc744 \ubc14\uae65\uc758 \uc6d0\ub798 \ucee8\ud14d\uc2a4\ud2b8\uc5d0\uc11c \uac01\uac01 \uacc4\uc0b0\ud574 \ub461\ub2c8\ub2e4.<\/li>\n
    2. \ud604\uc7ac \ud544\ud130 \ucee8\ud14d\uc2a4\ud2b8\ub97c \ubcf5\uc0ac\ud558\uace0, \ud589 \ucee8\ud14d\uc2a4\ud2b8\ub294 \ubc84\ub9bd\ub2c8\ub2e4.<\/li>\n
    3. \ud589 \ucee8\ud14d\uc2a4\ud2b8\uac00 \uc788\uc5c8\ub2e4\uba74 \uadf8 \uac12\uc744 \ud544\ud130\ub85c \ubc14\uafd4 \ub123\uc2b5\ub2c8\ub2e4(\ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658).<\/li>\n
    4. USERELATIONSHIP, CROSSFILTER, ALL \uacc4\uc5f4 \uac19\uc740 \uc218\uc815 \ud568\uc218\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n
    5. \ub9c8\uc9c0\ub9c9\uc73c\ub85c 1\ubc88\uc5d0\uc11c \uacc4\uc0b0\ud55c \ud544\ud130 \uc778\uc218\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
      \uc2e4\ubb34\uc5d0\uc11c \uc774 \uc21c\uc11c\ub97c \uc804\ubd80 \uc678\uc6b8 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. “\ud544\ud130 \uc778\uc218\ub294 \ubc14\uae65 \uae30\uc900\uc73c\ub85c \uba3c\uc800 \uacc4\uc0b0\ub418\uace0, \uac19\uc740 \uc5f4\uc774\uba74 \ub36e\uc5b4\uc4f4\ub2e4” \uc815\ub3c4\ub9cc \uae30\uc5b5\ud574\ub3c4 \ub300\ubd80\ubd84\uc758 \uc758\ubb38\uc774 \ud480\ub9bd\ub2c8\ub2e4.<\/p>\n\n
      \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658<\/h2>\n\n
      CALCULATE\uc5d0\ub294 \ud544\ud130\ub97c \ud558\ub098\ub3c4 \ub123\uc9c0 \uc54a\uc544\ub3c4 \ud558\ub294 \uc77c\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ud589 \ucee8\ud14d\uc2a4\ud2b8\ub97c \ud544\ud130 \ucee8\ud14d\uc2a4\ud2b8\ub85c \ubc14\uafb8\ub294 \uac83<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n
      \uc608\ub97c \ub4e4\uc5b4 \uc0c1\ud488 \ud14c\uc774\ube14\uc5d0 \uacc4\uc0b0 \uc5f4\uc744 \ub9cc\ub4e0\ub2e4\uace0 \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc0c1\ud488 \ud14c\uc774\ube14\uacfc Sales \uc0ac\uc774\uc5d0 \uad00\uacc4\uac00 \uc788\ub2e4\uace0 \uac00\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n
      \uc0c1\ud488\ub9e4\ucd9c = SUM( Sales[\uae08\uc561] )                 -- \ubaa8\ub4e0 \uc904\uc5d0 320\n\uc0c1\ud488\ub9e4\ucd9c = CALCULATE( SUM( Sales[\uae08\uc561] ) )    -- \ub178\ud2b8\ubd81 220, \ub9c8\uc6b0\uc2a4 30, \ubaa8\ub2c8\ud130 70<\/code><\/pre>\n\n
      \uccab \ubc88\uc9f8 \uc2dd\uc740 \uacc4\uc0b0 \uc5f4\uc758 \ud589 \ucee8\ud14d\uc2a4\ud2b8\uac00 Sales\ub97c \uac78\ub7ec\uc8fc\uc9c0 \ubabb\ud574\uc11c \ubaa8\ub4e0 \uc904\uc5d0 \uc804\uccb4 \ud569\uacc4 320\uc774 \ub4e4\uc5b4\uac11\ub2c8\ub2e4. \ub450 \ubc88\uc9f8 \uc2dd\uc740 CALCULATE\uac00 “\ud604\uc7ac \ud589\uc758 \uc0c1\ud488”\uc744 \ud544\ud130\ub85c \ubc14\uafd4\uc11c \uadf8 \uc0c1\ud488\uc758 \ud569\uacc4\ub9cc \uacc4\uc0b0\ud569\ub2c8\ub2e4.<\/p>\n\n
      \uc774 \ub3d9\uc791\uc740 SUMX \uac19\uc740 \ubc18\ubcf5 \ud568\uc218 \uc548\uc5d0\uc11c\ub3c4 \uc77c\uc5b4\ub0a9\ub2c8\ub2e4. \ud55c \uac00\uc9c0 \ud3b8\ud55c \uc810\uc740, \uc774\ubbf8 \ub9cc\ub4e4\uc5b4 \ub454 \uce21\uc815\uac12\uc744 \ud589 \ucee8\ud14d\uc2a4\ud2b8 \uc548\uc5d0\uc11c \ucc38\uc870\ud558\uba74 CALCULATE\ub97c \uc9c1\uc811 \uc4f0\uc9c0 \uc54a\uc544\ub3c4 \uc790\ub3d9\uc73c\ub85c \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\uc774 \uc77c\uc5b4\ub09c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uce21\uc815\uac12 \ucc38\uc870\uac00 \ub0b4\ubd80\uc801\uc73c\ub85c CALCULATE\ub97c \uac10\uc2f8\ub294 \uac83\uacfc \uac19\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ubc18\ub300\ub85c \ub9d0\ud558\uba74, \ubc18\ubcf5 \ud568\uc218 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc744 \uc4f8 \ub54c \uac12\uc774 \uc608\uc0c1 \ubc16\uc73c\ub85c \ub098\uc624\uba74 \uc774 \uc804\ud658\uc774 \uc6d0\uc778\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
      \uc4f8 \ub54c \uac78\ub9ac\ub294 \uc81c\uc57d<\/h2>\n\n
        \n
      • \ucc38\/\uac70\uc9d3 \uc870\uac74\uc5d0\ub294 \ud55c \ud14c\uc774\ube14\uc758 \uc5f4<\/strong>\ub9cc \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
      • \ucc38\/\uac70\uc9d3 \uc870\uac74 \uc548\uc5d0\uc11c \uce21\uc815\uac12\uc744 \ucc38\uc870\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4<\/strong>. \uce21\uc815\uac12 \uae30\uc900\uc73c\ub85c \uac70\ub974\ub824\uba74 FILTER\ub85c \ud14c\uc774\ube14 \ud544\ud130\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
      • \ucc38\/\uac70\uc9d3 \uc870\uac74 \uc548\uc5d0 CALCULATE\ub97c \uacb9\uccd0 \uc4f8 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n
      • DirectQuery \ubaa8\ub4dc\uc5d0\uc11c\ub294 \uacc4\uc0b0 \uc5f4\uacfc \ud589 \uc218\uc900 \ubcf4\uc548 \uaddc\uce59 \uc548\uc5d0\uc11c CALCULATE\ub97c \uc4f8 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
        FILTER\ub85c \ud14c\uc774\ube14 \uc804\uccb4\ub97c \uac70\ub294 \ubc29\uc2dd\ub3c4 \uac00\ub2a5\uc740 \ud569\ub2c8\ub2e4. \ub2e4\ub9cc SQLBI\ub294 \uc5f4 \ub2e8\uc704\ub85c \uac70\ub294 \uac83\uc774 \ub354 \uac00\ubccd\uace0 \uc758\ubbf8\uc0c1 \uc548\uc804\ud558\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. FILTER\ub97c \ud14c\uc774\ube14 \ud1b5\uc9f8\ub85c \uac78\uba74 \uadf8 \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \uc5f4\uc774 \uc601\ud5a5\uc744 \ubc1b\uc544\uc11c \uc608\uc0c1 \ubabb\ud55c \uacb0\uacfc\uac00 \ub098\uc62c \uc218 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uaf2d \ud544\uc694\ud558\uc9c0 \uc54a\ub2e4\uba74 \uc5f4 \ub2e8\uc704 \uc870\uac74\uc744 \uba3c\uc800 \uace0\ub824\ud558\uc138\uc694.<\/p>\n\n
        \uc790\uc8fc \ud558\ub294 \uc2e4\uc218<\/h2>\n\n
          \n
        1. \ubaa8\ub4e0 \uc904\uc5d0 \uac19\uc740 \uac12\uc774 \ub098\uc628\ub2e4<\/strong>: \uac19\uc740 \uc5f4\uc758 \ud544\ud130\ub97c \ub36e\uc5b4\uc4f4 \uacbd\uc6b0\uc785\ub2c8\ub2e4. \uc758\ub3c4\ud55c \uacb0\uacfc\uc778\uc9c0 \ubcf4\uace0, \uacb9\uccd0\uc57c \ud558\uba74 KEEPFILTERS\ub97c \uc501\ub2c8\ub2e4.<\/li>\n
        2. \uc870\uac74\uc5d0 \uce21\uc815\uac12\uc744 \ub123\uc5c8\ub354\ub2c8 \uc624\ub958\uac00 \ub09c\ub2e4<\/strong>: \ucc38\/\uac70\uc9d3 \uc870\uac74\uc5d0\uc11c\ub294 \uce21\uc815\uac12\uc744 \uc4f8 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n
        3. \uacc4\uc0b0 \uc5f4 \uac12\uc774 \uc804\ubd80 \uac19\ub2e4<\/strong>: \ud589 \ucee8\ud14d\uc2a4\ud2b8\ub97c \ud544\ud130\ub85c \ubc14\uafb8\ub294 CALCULATE\ub97c \ube7c\uba39\uc5c8\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
        4. \uc218\uc2dd \uc624\ub958\uac00 \ub09c\ub2e4<\/strong>: \uad04\ud638\uc640 \uc27c\ud45c\ub97c \ud655\uc778\ud558\uc138\uc694. \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.<\/li>\n<\/ol>\n\n
          \ube44\uc2b7\ud55c \ud568\uc218\uc640\uc758 \ucc28\uc774<\/h2>\n\n
            \n
          • CALCULATETABLE<\/strong>: \ud544\ud130\ub97c \ubc14\uafb8\ub294 \ubc29\uc2dd\uc740 \uac19\uace0, \uacb0\uacfc\ub85c \uac12\uc774 \uc544\ub2c8\ub77c \ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc90d\ub2c8\ub2e4.<\/li>\n
          • SUMX<\/strong>: \ud14c\uc774\ube14\uc744 \ud55c \uc904\uc529 \ub3cc\uba70 \uc2dd\uc744 \uacc4\uc0b0\ud574 \ub354\ud569\ub2c8\ub2e4. \ud544\ud130 \ucee8\ud14d\uc2a4\ud2b8\ub97c \ubc14\uafb8\ub294 \ud568\uc218\uac00 \uc544\ub2d9\ub2c8\ub2e4.<\/li>\n
          • FILTER<\/strong>: \uc870\uac74\uc5d0 \ub9de\ub294 \ud589\ub9cc \ub0a8\uae34 \ud14c\uc774\ube14\uc744 \ub9cc\ub4ed\ub2c8\ub2e4. CALCULATE\uc758 \ud544\ud130 \uc778\uc218\ub85c \uc790\uc8fc \ub4e4\uc5b4\uac11\ub2c8\ub2e4.<\/li>\n
          • REMOVEFILTERS \/ ALL<\/strong>: CALCULATE \uc548\uc5d0\uc11c \ud544\ud130\ub97c \uac77\uc5b4\ub0bc \ub54c \uc501\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
            \uc815\ub9ac<\/h2>\n\n
            CALCULATE\ub294 \uacb0\uad6d “\uc9c0\uae08 \uac78\ub9b0 \ud544\ud130\ub97c \ub0b4\uac00 \uc6d0\ud558\ub294 \ubaa8\uc591\uc73c\ub85c \ubc14\uafd4\uc11c \ub2e4\uc2dc \uacc4\uc0b0\ud55c\ub2e4”\ub294 \ud55c \uac00\uc9c0 \uc77c\uc744 \ud569\ub2c8\ub2e4. \uac19\uc740 \uc5f4\uc774\uba74 \ub36e\uc5b4\uc4f0\uace0, \uacb9\uce58\uace0 \uc2f6\uc73c\uba74 KEEPFILTERS, \uc9c0\uc6b0\uace0 \uc2f6\uc73c\uba74 REMOVEFILTERS, \ud589 \ucee8\ud14d\uc2a4\ud2b8\uac00 \uc788\uc73c\uba74 \ud544\ud130\ub85c \ubc14\uafd4 \uc90d\ub2c8\ub2e4. \uc774 \ub124 \uac00\uc9c0\ub9cc \uad6c\ubd84\ud574\ub3c4 \uc774\ud6c4\uc5d0 \ub098\uc624\ub294 \uc2dc\uac04 \ube44\uad50 \ud568\uc218\ub098 \ube44\uc728 \uacc4\uc0b0\uc774 \ud6e8\uc52c \uc77d\uae30 \uc26c\uc6cc\uc9d1\ub2c8\ub2e4.<\/p>\n\n
            \uc774 \uae00\uc758 \uc608\uc81c\ub294 \uac00\uc0c1 \ub370\uc774\ud130\uc774\ub2c8, \uc9c1\uc811 \ub530\ub77c \ud558\uc2e4 \ub54c\ub294 \ubcf8\uc778 \ubaa8\ub378\uc758 \uc5f4 \uc774\ub984\uc73c\ub85c \ubc14\uafd4\uc11c \ud655\uc778\ud574 \ubcf4\uc138\uc694. \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 \ubcf4\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4.<\/p>\n\n
            \ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n
              \n
            • Microsoft Learn, CALCULATE function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/calculate-function-dax<\/li>\n
            • DAX Guide, CALCULATE: https:\/\/dax.guide\/calculate\/<\/li>\n
            • SQLBI, Introducing CALCULATE in DAX: https:\/\/www.sqlbi.com\/articles\/introducing-calculate-in-dax\/<\/li>\n
            • SQLBI, Specifying multiple filter conditions in CALCULATE: https:\/\/www.sqlbi.com\/articles\/specifying-multiple-filter-conditions-in-calculate\/<\/li>\n
            • 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":"
              DAX CALCULATE \ud568\uc218\uc758 \ubb38\ubc95, \ud544\ud130 \ub36e\uc5b4\uc4f0\uae30, KEEPFILTERS, \ucee8\ud14d\uc2a4\ud2b8 \uc804\ud658\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":[5,4,6],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-calculate","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\/19","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=19"}],"version-history":[{"count":0,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}