{"id":27,"date":"2026-10-04T10:28:26","date_gmt":"2026-10-04T01:28:26","guid":{"rendered":"https:\/\/vera-b.com\/?p=27"},"modified":"2026-10-04T10:28:26","modified_gmt":"2026-10-04T01:28:26","slug":"dax-counta-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ec%b0%b8-%ea%b1%b0%ec%a7%93-%ec%97%b4%ea%b9%8c%ec%a7%80-%ec%84%b8%eb%8a%94-%ea%b0%9c%ec%88%98-%ed%95%a8%ec%88%98","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=27","title":{"rendered":"DAX COUNTA \ud568\uc218 \uc815\ub9ac: \ucc38\/\uac70\uc9d3 \uc5f4\uae4c\uc9c0 \uc138\ub294 \uac1c\uc218 \ud568\uc218"},"content":{"rendered":"\n

COUNT\ub97c \uc4f0\ub2e4\uac00 “\ucc38\/\uac70\uc9d3 \uc5f4\uc740 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4”\ub294 \uc548\ub0b4\ub97c \ub9cc\ub098\uba74 \uc790\uc5f0\uc2a4\ub7fd\uac8c \ucc3e\uac8c \ub418\ub294 \ud568\uc218\uac00 COUNTA\uc785\ub2c8\ub2e4. \uc774\ub984\uc774 \ube44\uc2b7\ud574\uc11c \uadf8\ub0e5 \ub118\uc5b4\uac00\uae30 \uc26c\uc6b4\ub370, \uc5b4\ub514\uac00 \uac19\uace0 \uc5b4\ub514\uac00 \ub2e4\ub978\uc9c0 \ud55c \ubc88 \uc815\ub9ac\ud574 \ub450\uba74 \uac1c\uc218 \ud568\uc218 \uace0\ub974\ub294 \uc77c\uc774 \ud6e8\uc52c \ud3b8\ud574\uc9d1\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 COUNTA\uc758 \ub3d9\uc791\uacfc \ube48 \ubb38\uc790\uc5f4\uc774\ub77c\ub294 \ud568\uc815, \uadf8\ub9ac\uace0 \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \ub9de\ub2e5\ub728\ub9ac\ub294 \uc138 \uac00\uc9c0 \uc0c1\ud669(\uc5f0\ub77d\ucc98 \ud655\ubcf4\uc728, \uc870\uac74\ubd80 \uac1c\uc218, \ucc38\/\uac70\uc9d3 \uc5f4)\uc744 \uac19\uc740 \ub370\uc774\ud130\ub85c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n

\ubb38\ubc95\uacfc \ubc18\ud658\uac12<\/h2>\n\n
COUNTA( <\uc5f4> )<\/code><\/pre>\n\n
\uc778\uc218\ub294 \uc5f4 \ud558\ub098\uc774\uace0, \uadf8 \uc5f4\uc5d0\uc11c \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \ud589\uc758 \uc218<\/strong>\ub97c \uc815\uc218\ub85c \ub3cc\ub824\uc90d\ub2c8\ub2e4. \uc138\uc5b4\ubcfc \ud589\uc774 \ud558\ub098\ub3c4 \uc5c6\uc73c\uba74 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12(BLANK)\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uac00 \uc124\uba85\ud558\ub294 COUNT\uc640\uc758 \uac00\uc7a5 \ud070 \ucc28\uc774\ub294 \ud55c \uc904\uc785\ub2c8\ub2e4. COUNTA\ub294 \ucc38\/\uac70\uc9d3(Boolean) \ud615\uc2dd\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. COUNT \uc790\uccb4\ub294 COUNT \ud568\uc218 \uae00<\/a>\uc5d0\uc11c \uc815\ub9ac\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n\n
Power BI Desktop\uc5d0\uc11c \uce21\uc815\uac12\uc73c\ub85c \ub9cc\ub4e4\uae30<\/h2>\n\n
\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
    \n
  1. \ubcf4\uace0\uc11c \ubcf4\uae30\uc5d0\uc11c \uc624\ub978\ucabd \ud544\ub4dc \ucc3d\uc758 \ud14c\uc774\ube14(\uc608: \ud68c\uc6d0)\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<\/li>\n
  2. \uc0c1\ub2e8 \ub9ac\ubcf8\uc5d0\uc11c “\uc0c8 \uce21\uc815\uac12”(\uc601\ubb38\ud310\uc740 New measure)\uc744 \ub204\ub985\ub2c8\ub2e4.<\/li>\n
  3. \uc218\uc2dd \uc785\ub825\uc904\uc5d0 \uc774\uba54\uc77c\uac1c\uc218 = COUNTA( \ud68c\uc6d0[\uc774\uba54\uc77c] )<\/code>\ucc98\ub7fc \uc774\ub984\uacfc \uc2dd\uc744 \uc801\uace0 Enter\ub97c \ub204\ub985\ub2c8\ub2e4.<\/li>\n
  4. \ub9cc\ub4e0 \uce21\uc815\uac12\uc744 \uce74\ub4dc \uc2dc\uac01\ud654\uc5d0 \uc62c\ub824 \uac12\uc744 \ud655\uc778\ud558\uace0, \uc0c1\ud0dc \uac19\uc740 \uc5f4\uacfc \ud568\uaed8 \ud45c\uc5d0 \uc62c\ub824 \uc904\ub9c8\ub2e4 \uc5b4\ub5bb\uac8c \ub098\ub258\ub294\uc9c0 \ubd05\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
    \uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
    \uc124\uba85\ud558\ub824\uace0 \ub9cc\ub4e0 \uac00\uc0c1 \ud68c\uc6d0 \ud45c\uc785\ub2c8\ub2e4. \uc774\uba54\uc77c\uc774 \uc5c6\ub294 \ud68c\uc6d0, \uc804\ud654\ubc88\ud638 \uce78\uc5d0 \ube48 \ubb38\uc790\uc5f4\uc774 \ub4e4\uc5b4\uac04 \ud68c\uc6d0, \uc804\ud654\ubc88\ud638\uac00 \uc644\uc804\ud788 \ube44\uc5b4 \uc788\ub294 \ud68c\uc6d0\uc744 \uc77c\ubd80\ub7ec \uc11e\uc5c8\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\ub294 Power BI\uc5d0\uc11c \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uc9c1\uc811 \uc138\uc5b4\uc11c \uc801\uc740 \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\n\n
    \ud68c\uc6d0<\/th>\uc774\uba54\uc77c<\/th>\uc804\ud654\ubc88\ud638<\/th>\ub9c8\ucf00\ud305\ub3d9\uc758<\/th>\uc0c1\ud0dc<\/th><\/tr><\/thead>\n
    1<\/td>a@example.com<\/td>010-1111<\/td>TRUE<\/td>\ud65c\uc131<\/td><\/tr>\n
    2<\/td>(\ube48 \uac12)<\/td>010-2222<\/td>FALSE<\/td>\ud65c\uc131<\/td><\/tr>\n
    3<\/td>c@example.com<\/td>“” (\ube48 \ubb38\uc790\uc5f4)<\/td>TRUE<\/td>\ud734\uba74<\/td><\/tr>\n
    4<\/td>d@example.com<\/td>(\ube48 \uac12)<\/td>FALSE<\/td>\ud65c\uc131<\/td><\/tr>\n
    5<\/td>(\ube48 \uac12)<\/td>010-5555<\/td>TRUE<\/td>\ud734\uba74<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc5f4\ub9c8\ub2e4 \uc138\uc5b4 \ubcf4\uae30<\/h2>\n\n
    \uc774\uba54\uc77c\uac1c\uc218 = COUNTA( \ud68c\uc6d0[\uc774\uba54\uc77c] )<\/code><\/pre>\n\n
    \uc774\uba54\uc77c\uc774 \uc788\ub294 \ud68c\uc6d0\uc740 1, 3, 4\ubc88\uc774\ub77c 3<\/strong>\uc785\ub2c8\ub2e4.<\/p>\n\n
    \ub3d9\uc758\uc5f4\uac1c\uc218 = COUNTA( \ud68c\uc6d0[\ub9c8\ucf00\ud305\ub3d9\uc758] )<\/code><\/pre>\n\n
    \ucc38\/\uac70\uc9d3 \uc5f4\uc774\ub77c\uc11c COUNT\ub85c\ub294 \uc140 \uc218 \uc5c6\uace0, COUNTA\ub85c\ub294 \ubaa8\ub4e0 \ud589\uc5d0 \uac12\uc774 \uc788\uc73c\ub2c8 5<\/strong>\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774 5\ub294 “\ub3d9\uc758\ud55c \uc0ac\ub78c \uc218”\uac00 \uc544\ub2c8\ub77c “\ub3d9\uc758 \uc5ec\ubd80\uac00 \uae30\ub85d\ub41c \ud589 \uc218”\uc785\ub2c8\ub2e4. \uc774 \uad6c\ubd84\uc740 \uc2dc\ub098\ub9ac\uc624 3\uc5d0\uc11c \ub2e4\uc2dc \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n\n
    \ube48 \ubb38\uc790\uc5f4\uc740 \uc13c\ub2e4<\/h2>\n\n
    \uc804\ud654\ubc88\ud638\uac1c\uc218 = COUNTA( \ud68c\uc6d0[\uc804\ud654\ubc88\ud638] )<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 4<\/strong>\uc785\ub2c8\ub2e4. 1\ubc88, 2\ubc88, 5\ubc88\uc758 \uc804\ud654\ubc88\ud638\uc5d0 3\ubc88\uc758 \ube48 \ubb38\uc790\uc5f4\uc774 \ub354\ud574\uc9c4 \uac12\uc785\ub2c8\ub2e4. DAX Guide\uc5d0 \ub530\ub974\uba74 COUNTA\ub294 \uc9c4\uc9dc \ube48 \uac12(BLANK)\uc740 \uc138\uc9c0 \uc54a\uc9c0\ub9cc \ube48 \ubb38\uc790\uc5f4(“”)\uc740 \uc13c\ub2e4<\/strong>\uace0 \ud569\ub2c8\ub2e4. \ud654\uba74\uc5d0\uc11c\ub294 3\ubc88\uacfc 4\ubc88 \uce78\uc774 \ub611\uac19\uc774 \ube44\uc5b4 \ubcf4\uc774\uc9c0\ub9cc \uc9d1\uacc4\uc5d0\uc11c\ub294 \ub2e4\ub974\uac8c \ucde8\uae09\ub429\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc758 \uac1c\ub150 \uc124\uba85\uc5d0\uc11c\ub3c4 BLANK\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 null\uc744 \ub300\uc2e0\ud558\ub294 \ubcc4\ub3c4\uc758 \uac12 \ud615\uc2dd\uc774\uace0, \ube48 \ubb38\uc790\uc5f4\uacfc\ub294 \ub2e4\ub978 \uac12\uc785\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \uc5f0\ub77d\ucc98 \ud655\ubcf4\uc728<\/h2>\n\n
    \ub9c8\ucf00\ud305 \ub2f4\ub2f9\uc790\uac00 “\uc774\uba54\uc77c\uacfc \uc804\ud654\ubc88\ud638\ub97c \ud655\ubcf4\ud55c \ube44\uc728”\uc744 \ubb3b\ub294\ub2e4\uace0 \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\uba54\uc77c\ubd80\ud130 \uad6c\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc774\uba54\uc77c\ud655\ubcf4\uc728 =\nDIVIDE( COUNTA( \ud68c\uc6d0[\uc774\uba54\uc77c] ), COUNTROWS( \ud68c\uc6d0 ) )<\/code><\/pre>\n\n
    3 \u00f7 5 = 60%<\/strong>\uc785\ub2c8\ub2e4. \uc804\uccb4 \ud68c\uc6d0 \uc218 \uc790\ub9ac\uc5d0\ub294 COUNTROWS\ub97c \uc37c\uc2b5\ub2c8\ub2e4. \uc5f4 \uac12\uc758 \uc720\ubb34\uc640 \uc0c1\uad00\uc5c6\uc774 \ud14c\uc774\ube14\uc758 \ud589 \uc218\ub97c \uc138\ub294 \ud568\uc218\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uac19\uc740 \ubc29\uc2dd\uc73c\ub85c \uc804\ud654\ubc88\ud638 \ud655\ubcf4\uc728\uc744 \uad6c\ud558\uba74 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc804\ud654\ubc88\ud638\ud655\ubcf4\uc728_\uc21c\uc9c4\ud55c\uc2dd =\nDIVIDE( COUNTA( \ud68c\uc6d0[\uc804\ud654\ubc88\ud638] ), COUNTROWS( \ud68c\uc6d0 ) )<\/code><\/pre>\n\n
    4 \u00f7 5 = 80%\uac00 \ub098\uc624\ub294\ub370, \uc2e4\uc81c\ub85c \ubc88\ud638\uac00 \uc801\ud600 \uc788\ub294 \ud68c\uc6d0\uc740 1\ubc88, 2\ubc88, 5\ubc88 \uc138 \uba85\ubfd0\uc774\ub2c8 \ub9de\ub294 \uac12\uc740 60%\uc785\ub2c8\ub2e4. 3\ubc88\uc758 \ube48 \ubb38\uc790\uc5f4\uc774 “\uac12\uc774 \uc788\ub294 \ud589”\uc73c\ub85c \uc138\uc5b4\uc84c\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ubc88\ud638\uac00 \uc2e4\uc81c\ub85c \uc801\ud78c \ud68c\uc6d0\ub9cc \uc138\ub824\uba74 \uae38\uc774\ub97c \ud655\uc778\ud558\ub294 \uc870\uac74\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc804\ud654\ubc88\ud638\uc785\ub825\ud68c\uc6d0 =\nCALCULATE(\n    COUNTROWS( \ud68c\uc6d0 ),\n    LEN( \ud68c\uc6d0[\uc804\ud654\ubc88\ud638] ) > 0\n)<\/code><\/pre>\n\n
    \ube48 \uac12\uacfc \ube48 \ubb38\uc790\uc5f4 \ubaa8\ub450 \uae38\uc774\uac00 0\uc774\ub77c\uc11c \uac78\ub7ec\uc9c0\uace0, 1, 2, 5\ubc88\ub9cc \ub0a8\uc544 3<\/strong>\uc774 \ub429\ub2c8\ub2e4. \ud655\ubcf4\uc728\uc740 3 \u00f7 5 = 60%\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c \uc5f4\uc744 \uadf8\ub0e5 COUNTA\ub85c \uc138\uba74 “\uc785\ub825 \uce78\uc774 \uc788\ub294 \ud589”\uacfc “\ub0b4\uc6a9\uc774 \uc788\ub294 \ud589”\uc774 \ub2ec\ub77c\uc9c8 \uc218 \uc788\ub2e4\ub294 \uc810\uc744 \uae30\uc5b5\ud574 \ub450\uc138\uc694.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \uc870\uac74\uacfc \ud568\uaed8 \uc138\uae30 (COUNTAX)<\/h2>\n\n
    “\ud65c\uc131 \ud68c\uc6d0 \uc911 \uc774\uba54\uc77c\uc774 \uc788\ub294 \ud68c\uc6d0 \uc218”\ub294 \ub450 \uac00\uc9c0 \ubc29\ubc95\uc73c\ub85c \uc140 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\ub098\ub294 CALCULATE\ub85c \uc870\uac74\uc744 \ubc14\uafb8\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4.<\/p>\n\n
    \ud65c\uc131\uc774\uba54\uc77c\ud68c\uc6d0 =\nCALCULATE(\n    COUNTA( \ud68c\uc6d0[\uc774\uba54\uc77c] ),\n    \ud68c\uc6d0[\uc0c1\ud0dc] = \"\ud65c\uc131\"\n)<\/code><\/pre>\n\n
    \ud65c\uc131 \ud68c\uc6d0\uc740 1, 2, 4\ubc88\uc774\uace0 \uc774 \uc911 \uc774\uba54\uc77c\uc774 \uc788\ub294 \ud68c\uc6d0\uc740 1\ubc88\uacfc 4\ubc88\uc774\ub77c \uacb0\uacfc\ub294 2<\/strong>\uc785\ub2c8\ub2e4. CALCULATE\uac00 \uc870\uac74\uc744 \ubc14\uafb8\ub294 \uc6d0\ub9ac\ub294 CALCULATE \ud568\uc218 \uae00<\/a>\uc5d0 \uc815\ub9ac\ud574 \ub450\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \ud558\ub098\ub294 \ubc18\ubcf5 \ud568\uc218\uc778 COUNTAX\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc758 \uc608\uc81c\ub3c4 “\uc0c1\ud0dc\uac00 \ud65c\uc131\uc778 \uac70\ub798\ucc98\ub85c \uba3c\uc800 \uac78\ub7ec\ub0b8 \ud45c\uc5d0\uc11c \uc804\ud654\ubc88\ud638\uac00 \uc788\ub294 \ud589\uc744 \uc13c\ub2e4”\ub294 \uad6c\uc870\uc785\ub2c8\ub2e4.<\/p>\n\n
    \ud65c\uc131\uc774\uba54\uc77c\ud68c\uc6d0_AX =\nCOUNTAX(\n    FILTER( \ud68c\uc6d0, \ud68c\uc6d0[\uc0c1\ud0dc] = \"\ud65c\uc131\" ),\n    \ud68c\uc6d0[\uc774\uba54\uc77c]\n)<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 \uac19\uc740 2<\/strong>\uc785\ub2c8\ub2e4. DAX Guide\uc5d0 \ub530\ub974\uba74 COUNTA\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c COUNTAX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0 \uc131\ub2a5 \ucc28\uc774\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uc5f4 \ud558\ub098\ub97c \uc138\ub294 \uc77c\uc774\uba74 COUNTA\uc640 CALCULATE\uc758 \uc870\ud569\uc774 \uc77d\uae30 \uc27d\uace0, \uc138\ub294 \ub300\uc0c1\uc774 \uacc4\uc0b0\uc2dd\uc758 \uacb0\uacfc\ub77c\uba74 COUNTAX\ub97c \uc4f0\ub294 \ud3b8\uc774 \uc790\uc5f0\uc2a4\ub7fd\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    COUNTAX\uc5d0\ub294 Microsoft \ubb38\uc11c\uac00 \ub530\ub85c \uc54c\ub824\uc8fc\ub294 \uc8fc\uc758\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc2dd\uc758 \uacb0\uacfc\uac00 \ube48 \ubb38\uc790\uc5f4\uc774\uba74 \uadf8 \uacb0\uacfc\ub294 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uac12\uc73c\ub85c \uc138\uc5b4\uc9c4\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \uc774\uba54\uc77c\uc5d0 \ube48 \ubb38\uc790\uc5f4\uc744 \uc774\uc5b4 \ubd99\uc774\ub294 \uc2dd\uc744 \uc138\uba74, \uc6d0\ub798 \ube44\uc5b4 \uc788\ub358 \uc774\uba54\uc77c\ub3c4 \ubb38\uc790\uc5f4 \uacb0\ud569 \uacb0\uacfc(\ube48 \ubb38\uc790\uc5f4)\uac00 \ub418\uc5b4 \uc138\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc774\uba54\uc77c_\uacb0\ud569\ud6c4\uac1c\uc218 =\nCOUNTAX( \ud68c\uc6d0, \ud68c\uc6d0[\uc774\uba54\uc77c] & \"\" )<\/code><\/pre>\n\n
    \ubb38\uc11c\uc758 \uaddc\uce59\ub300\ub85c\ub77c\uba74 \uc774 \uc2dd\uc740 \ubaa8\ub4e0 \ud589\uc774 \uc138\uc5b4\uc838 5\uac00 \ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub2e4\ub9cc \uc774 \ubd80\ubd84\uc740 \uc81c\uac00 Power BI\uc5d0\uc11c \uc9c1\uc811 \ub3cc\ub824 \ud655\uc778\ud55c \uac83\uc774 \uc544\ub2c8\ub77c \ubb38\uc11c\uc758 \uc124\uba85\uc744 \ub530\ub77c \uc801\uc740 \uac83\uc774\ubbc0\ub85c, \uc4f0\uc2dc\ub294 \ud658\uacbd\uc5d0\uc11c \uacb0\uacfc\ub97c \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc2dc\uae38 \uad8c\ud569\ub2c8\ub2e4. \ud575\uc2ec\uc740 “\uc2dd\uc758 \uacb0\uacfc\uac00 \ube48 \uac12\uc778\uc9c0 \ube48 \ubb38\uc790\uc5f4\uc778\uc9c0\uc5d0 \ub530\ub77c \uac1c\uc218\uac00 \ub2ec\ub77c\uc9c4\ub2e4”\ub294 \uc810\uc785\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \ucc38\/\uac70\uc9d3 \uc5f4\uc758 \uc751\ub2f5\ub960\uacfc \ub3d9\uc758\uc728<\/h2>\n\n
    \ub9c8\ucf00\ud305 \ub3d9\uc758 \uc5f4\uc740 \ucc38\/\uac70\uc9d3 \ud615\uc2dd\uc774\ub77c COUNT\ub85c\ub294 \uc140 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \uba3c\uc800 “\ub3d9\uc758 \uc5ec\ubd80\uac00 \uae30\ub85d\ub41c \ube44\uc728”\uc740 \uc774\ub807\uac8c \uad6c\ud569\ub2c8\ub2e4.<\/p>\n\n
    \ub3d9\uc758\uae30\ub85d\ub960 =\nDIVIDE( COUNTA( \ud68c\uc6d0[\ub9c8\ucf00\ud305\ub3d9\uc758] ), COUNTROWS( \ud68c\uc6d0 ) )<\/code><\/pre>\n\n
    5 \u00f7 5 = 100%\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 \ud68c\uc6d0\uc5d0\uac8c \ub3d9\uc758 \uc5ec\ubd80\uac00 \uae30\ub85d\ub418\uc5b4 \uc788\ub2e4\ub294 \ub73b\uc77c \ubfd0, \ub3d9\uc758\ud55c \uc0ac\ub78c\uc758 \ube44\uc728\uc740 \uc544\ub2d9\ub2c8\ub2e4. \ub3d9\uc758\uc728\uc740 \ucc38\uc778 \ud589\ub9cc \ub530\ub85c \uc138\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n
    \ub3d9\uc758\uc728 =\nDIVIDE(\n    CALCULATE( COUNTROWS( \ud68c\uc6d0 ), \ud68c\uc6d0[\ub9c8\ucf00\ud305\ub3d9\uc758] = TRUE() ),\n    COUNTROWS( \ud68c\uc6d0 )\n)<\/code><\/pre>\n\n
    \ucc38\uc778 \ud68c\uc6d0\uc740 1, 3, 5\ubc88\uc774\ub77c 3 \u00f7 5 = 60%<\/strong>\uc785\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc5d0 “\ub3d9\uc758 100%”\ub77c\uace0 \uc798\ubabb \uc801\ub294 \uc77c\uc774 \uc0dd\uae30\uc9c0 \uc54a\uc73c\ub824\uba74 \uc5b4\ub5a4 \ube44\uc728\uc778\uc9c0 \uc774\ub984\uc744 \ubd84\uba85\ud788 \ubd99\uc774\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    COUNT\uc640 \ubb34\uc5c7\uc774 \uac19\uace0 \ub2e4\ub978\uac00<\/h2>\n\n\n\n
    \uad6c\ubd84<\/th>COUNT<\/th>COUNTA<\/th><\/tr><\/thead>\n
    \uc22b\uc790, \ub0a0\uc9dc, \ubb38\uc790\uc5f4 \uc5f4<\/td>\uac12\uc774 \uc788\ub294 \ud589\uc744 \uc13c\ub2e4<\/td>\uac19\uc740 \uacb0\uacfc<\/td><\/tr>\n
    \ucc38\/\uac70\uc9d3 \uc5f4<\/td>\uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc74c<\/td>\uac12\uc774 \uc788\ub294 \ud589\uc744 \uc13c\ub2e4<\/td><\/tr>\n
    \ube48 \uac12<\/td>\uc138\uc9c0 \uc54a\uc74c<\/td>\uc138\uc9c0 \uc54a\uc74c<\/td><\/tr>\n
    \ube48 \ubb38\uc790\uc5f4<\/td>\uc13c\ub2e4<\/td>\uc13c\ub2e4<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    DAX Guide\ub294 \ucc38\/\uac70\uc9d3\uc774 \uc544\ub2cc \uc5f4\uc5d0\uc11c\ub294 \ub450 \ud568\uc218\uac00 \uc644\uc804\ud788 \uac19\uc740 \uacb0\uacfc\ub97c \ub0b8\ub2e4\uace0 \uc815\ub9ac\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub2c8 COUNT\ub97c \uc4f8 \uc218 \uc788\ub294 \uc5f4\uc774\ub77c\uba74 \uad73\uc774 COUNTA\ub85c \ubc14\uafc0 \uc774\uc720\ub294 \uc5c6\uace0, \uc5f4 \ud615\uc2dd\uc774 \ucc38\/\uac70\uc9d3\uc77c \ub54c\ub9cc COUNTA\ub97c \uace0\ub974\uba74 \ub429\ub2c8\ub2e4. \ubc18\ubcf5 \ud568\uc218 \ucabd\ub3c4 \uac19\uc740 \uad00\uacc4\uc785\ub2c8\ub2e4. DAX Guide\uc5d0 \ub530\ub974\uba74 COUNTX\uc640 COUNTAX\ub294 \ucc38\/\uac70\uc9d3 \ud615\uc2dd\uc744 \ube7c\uba74 \uac19\uace0, COUNTAX\ub294 \ucc38\/\uac70\uc9d3\ub3c4 \ucc98\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n
    \ub0b4\ubd80 \ub3d9\uc791\uacfc \uc131\ub2a5<\/h2>\n\n
    DAX Guide\uc758 \uc124\uba85\uc73c\ub85c\ub294 COUNTA\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c COUNTAX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0, \ub458 \uc0ac\uc774\uc5d0 \uc131\ub2a5 \ucc28\uc774\ub294 \uc5c6\ub2e4\uace0 \ud569\ub2c8\ub2e4. \ud589 \uc218 \uc790\uccb4\ub97c \uc138\ub824\ub294 \ubaa9\uc801\uc774\ub77c\uba74 \ud2b9\uc815 \uc5f4\uc758 \uac12 \uc720\ubb34\uc5d0 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294 COUNTROWS\uac00 \ub354 \uc54c\ub9de\uc2b5\ub2c8\ub2e4. Microsoft\ub294 COUNT \ub300\uc2e0 COUNTROWS\ub97c \uc4f0\ub77c\ub294 \ubaa8\ubc94 \uc0ac\ub840 \ubb38\uc11c\ub97c \ub530\ub85c \ub450\uace0 \uc788\uace0, \uc774\uc720\ub85c \ud6a8\uc728, \ube48 \uac12\uc5d0 \ub300\ud55c \uc601\ud5a5 \uc5c6\uc74c, \uc758\ub3c4\uac00 \ubd84\uba85\ud568\uc744 \ub4ed\ub2c8\ub2e4. \uac19\uc740 \uc774\uc720\uac00 COUNTA\uc5d0\ub3c4 \ub300\ubd80\ubd84 \ud574\ub2f9\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc4f0\uc9c0 \ub9d0\uc544\uc57c \ud560 \ub54c<\/h2>\n\n
      \n
    • \ud14c\uc774\ube14\uc758 \uc804\uccb4 \ud589 \uc218\uac00 \ud544\uc694\ud560 \ub54c<\/strong>: \uc5f4\uc774 \ube44\uc5b4 \uc788\ub294 \ud589\uc774 \ube60\uc9c0\ubbc0\ub85c COUNTROWS\ub97c \uc4f0\uc138\uc694.<\/li>\n
    • “\ucc38\uc778 \uac74\uc218”\uac00 \ud544\uc694\ud560 \ub54c<\/strong>: COUNTA\ub294 \uac12\uc774 \uae30\ub85d\ub41c \ud589\uc744 \uc140 \ubfd0\uc785\ub2c8\ub2e4. \uc870\uac74\uc744 \uac78\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
    • \uc11c\ub85c \ub2e4\ub978 \uac12\uc758 \uc218\uac00 \ud544\uc694\ud560 \ub54c<\/strong>: \uc911\ubcf5\ub3c4 \ubaa8\ub450 \uc138\uc5b4\uc9d1\ub2c8\ub2e4. DISTINCTCOUNT\uac00 \ub9de\uc2b5\ub2c8\ub2e4.<\/li>\n
    • \ube48 \ubb38\uc790\uc5f4\uc744 \ube48 \uac12\ucc98\ub7fc \ucde8\uae09\ud558\uace0 \uc2f6\uc744 \ub54c<\/strong>: \uae38\uc774\ub97c \ud655\uc778\ud558\ub294 \uc870\uac74\uc744 \ud568\uaed8 \uc4f0\uc138\uc694.<\/li>\n<\/ul>\n\n
      \uc54c\uc544\ub458 \uc810<\/h2>\n\n
        \n
      • \uc778\uc218\ub294 \uc5f4 \ud558\ub098\ubfd0\uc785\ub2c8\ub2e4. \ud14c\uc774\ube14\uc740 \ub123\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n
      • \uc13c \ud589\uc774 \uc5c6\uc73c\uba74 \ube48 \uac12\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4. 0\uc73c\ub85c \ubcf4\uc774\uac8c \ud558\uace0 \uc2f6\ub2e4\uba74 \ubcc4\ub3c4 \ucc98\ub9ac\uac00 \ud544\uc694\ud558\uba70, 0\uc744 \ub354\ud558\ub294 \ubc29\uc2dd\uc740 \ub370\uc774\ud130\uac00 \uc5c6\ub294 \ud56d\ubaa9\uae4c\uc9c0 0\uc73c\ub85c \ud45c\uc2dc\ub418\ub294 \ubd80\uc791\uc6a9\uc774 \uc788\ub2e4\uace0 SQLBI\uac00 \uc124\uba85\ud569\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
      • \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. \ucc38\/\uac70\uc9d3 \uc5f4 \uac1c\uc218\ub97c “\ucc38\uc778 \ud589 \uc218”\ub85c \ucc29\uac01<\/strong>: COUNTA\ub294 \uac12\uc774 \uae30\ub85d\ub41c \ud589\uc744 \uc140 \ubfd0, \ucc38\ub9cc \uc138\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n
        2. \ube48 \uce78\uc774 \uc804\ubd80 \uac19\ub2e4\uace0 \uc0dd\uac01<\/strong>: \ube48 \uac12\uacfc \ube48 \ubb38\uc790\uc5f4\uc740 \ub2e4\ub974\uac8c \uc9d1\uacc4\ub429\ub2c8\ub2e4.<\/li>\n
        3. \ud589 \uc218\ub97c \uc138\ub824\uace0 \uc544\ubb34 \uc5f4\uc774\ub098 COUNTA<\/strong>: \uadf8 \uc5f4\uc774 \ube48 \ud589\uc740 \ube60\uc9d1\ub2c8\ub2e4.<\/li>\n
        4. “\ud655\ubcf4\uc728”\uc744 COUNTA\ub85c\ub9cc \uacc4\uc0b0<\/strong>: \ube48 \ubb38\uc790\uc5f4 \ub54c\ubb38\uc5d0 \uc2e4\uc81c\ubcf4\ub2e4 \ub192\uac8c \ub098\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
          \uc815\ub9ac<\/h2>\n\n
          COUNTA\ub294 “\ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uac12\uc758 \uc218”\ub97c \uc138\ub294 \ud568\uc218\uc774\uace0, COUNT\uc640\uc758 \ucc28\uc774\ub294 \ucc38\/\uac70\uc9d3 \uc5f4 \uc9c0\uc6d0 \ud558\ub098\uc785\ub2c8\ub2e4. \ube48 \ubb38\uc790\uc5f4\uc740 \uac12\uc73c\ub85c \uc138\uc5b4\uc9c4\ub2e4\ub294 \uc810, \ucc38\/\uac70\uc9d3 \uc5f4\uc5d0\uc11c \uc5bb\uc740 \uac1c\uc218\uac00 \ucc38\uc758 \uac1c\uc218\uac00 \uc544\ub2c8\ub77c\ub294 \uc810, \uadf8\ub9ac\uace0 \ube44\uc728\uc744 \uad6c\ud560 \ub54c \ubd84\ubaa8\ub97c COUNTROWS\ub85c \uc7a1\uc544\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
          \ucc38\uace0\ud55c \uc790\ub8cc<\/h2>\n
            \n
          • Microsoft Learn, COUNTA function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/counta-function-dax<\/li>\n
          • Microsoft Learn, COUNTAX function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/countax-function-dax<\/li>\n
          • Microsoft Learn, DAX overview: https:\/\/learn.microsoft.com\/en-us\/dax\/dax-overview<\/li>\n
          • DAX Guide, COUNTA: https:\/\/dax.guide\/counta\/<\/li>\n
          • DAX Guide, COUNTAX: https:\/\/dax.guide\/countax\/<\/li>\n
          • SQLBI, How to return 0 instead of BLANK in DAX: https:\/\/www.sqlbi.com\/articles\/how-to-return-0-instead-of-blank-in-dax\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
            DAX COUNTA \ud568\uc218\uc758 \ub3d9\uc791, \ube48 \ubb38\uc790\uc5f4\uc758 \ud568\uc815, \uc5f0\ub77d\ucc98 \ud655\ubcf4\uc728\u00b7\uc870\uac74\ubd80 \uac1c\uc218(COUNTAX)\u00b7\ucc38\/\uac70\uc9d3 \uc5f4 \uc2dc\ub098\ub9ac\uc624\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":[11,4,6],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-counta","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\/27","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=27"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":34,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/27\/revisions\/34"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}