{"id":25,"date":"2026-10-03T08:07:29","date_gmt":"2026-10-02T23:07:29","guid":{"rendered":"https:\/\/vera-b.com\/?p=25"},"modified":"2026-10-03T08:07:29","modified_gmt":"2026-10-02T23:07:29","slug":"dax-count-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ea%b0%92%ec%9d%b4-%ec%9e%88%eb%8a%94-%ed%96%89%eb%a7%8c-%ec%84%b8%eb%8a%94-%eb%b0%a9%eb%b2%95%ea%b3%bc-counta-countrows%ec%99%80%ec%9d%98-%ec%b0%a8","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=25","title":{"rendered":"DAX COUNT \ud568\uc218 \uc815\ub9ac: \uac12\uc774 \uc788\ub294 \ud589\ub9cc \uc138\ub294 \ubc29\ubc95\uacfc COUNTA, COUNTROWS\uc640\uc758 \ucc28\uc774"},"content":{"rendered":"\n

“\uc8fc\ubb38\uc774 \uba87 \uac74\uc774\uc57c?”, “\ubc30\uc1a1\uc77c\uc774 \uc785\ub825\ub41c \uac74 \uba87 \uac1c\uc57c?” \uac19\uc740 \uc9c8\ubb38\uc5d0\ub294 \uac1c\uc218\ub97c \uc138\ub294 \ud568\uc218\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. DAX\uc5d0\ub294 COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT\ucc98\ub7fc \uc774\ub984\uc774 \ube44\uc2b7\ud55c \ud568\uc218\uac00 \uc5ec\ub7ff \uc788\uc5b4\uc11c \ucc98\uc74c\uc5d0\ub294 \ubb58 \uace8\ub77c\uc57c \ud560\uc9c0 \ud5f7\uac08\ub9bd\ub2c8\ub2e4. \uc774 \uae00\uc740 \uadf8\uc911 COUNT\ub97c \uc911\uc2ec\uc73c\ub85c, \ub098\uba38\uc9c0\uc640 \uc5b4\ub514\uc11c \uac08\ub9ac\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \uc4f0\ub294 \uc138 \uac00\uc9c0 \uc0c1\ud669(\uc785\ub825\ub960 \uc810\uac80, \uc870\uac74\ubd80 \uac1c\uc218, \uc2dd \uacb0\uacfc \uac1c\uc218)\uae4c\uc9c0 \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n

COUNT\ub294 \uc774\ub7f0 \ud568\uc218\uc785\ub2c8\ub2e4<\/h2>\n\n
COUNT( <\uc5f4> )<\/code><\/pre>\n\n
\uc778\uc218\ub294 \uc5f4 \ud558\ub098\ubfd0\uc774\uace0, \uadf8 \uc5f4\uc5d0\uc11c \uac12\uc774 \ub4e4\uc5b4 \uc788\ub294 \ud589\uc758 \uc218<\/strong>\ub97c \uc149\ub2c8\ub2e4. \ubc18\ud658\uac12\uc740 \uc815\uc218\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc5d0 \ub530\ub974\uba74 \uc22b\uc790, \ub0a0\uc9dc, \ubb38\uc790\uc5f4\uc774 \ub4e4\uc5b4 \uc788\ub294 \ud589\uc744 \uc138\uace0, \ube48 \uac12\uc740 \uac74\ub108\ub701\ub2c8\ub2e4. \uc13c \ud589\uc774 \ud558\ub098\ub3c4 \uc5c6\uc73c\uba74 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12\uc744 \ub3cc\ub824\uc90d\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: \uc8fc\ubb38)\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 \ubc30\uc1a1\uac74\uc218 = COUNT( \uc8fc\ubb38[\ubc30\uc1a1\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\ub098 \ud45c\uc5d0 \uc62c\ub824 \uac12\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. \ub2f4\ub2f9\uc790 \uac19\uc740 \uc5f4\uacfc \ud568\uaed8 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc904\ub9c8\ub2e4 \uc5b4\ub5bb\uac8c \ub098\ub258\ub294\uc9c0 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
    \uc608\uc81c \ub370\uc774\ud130<\/h2>\n\n
    \uc124\uba85\ud558\ub824\uace0 \ub9cc\ub4e0 \uac00\uc0c1 \ub370\uc774\ud130\uc785\ub2c8\ub2e4. \uc77c\ubd80\ub7ec \ube48 \uce78\uc744 \uba87 \uac1c \ub123\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
    \uc8fc\ubb38<\/th>\ub2f4\ub2f9\uc790<\/th>\ubc30\uc1a1\uc77c<\/th>\uc2b9\uc778(TRUE\/FALSE)<\/th>\uae08\uc561<\/th><\/tr><\/thead>\n
    1<\/td>\uae40<\/td>3\/2<\/td>TRUE<\/td>30<\/td><\/tr>\n
    2<\/td>\uc774<\/td>(\ube48 \uac12)<\/td>FALSE<\/td>20<\/td><\/tr>\n
    3<\/td>(\ube48 \uac12)<\/td>3\/5<\/td>TRUE<\/td>50<\/td><\/tr>\n
    4<\/td>\uae40<\/td>3\/7<\/td>TRUE<\/td>10<\/td><\/tr>\n
    5<\/td>\ubc15<\/td>(\ube48 \uac12)<\/td>FALSE<\/td>40<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uae30\ubcf8 \ub3d9\uc791<\/h2>\n\n
    \ubc30\uc1a1\uac74\uc218 = COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] )<\/code><\/pre>\n\n
    \ubc30\uc1a1\uc77c\uc774 \ucc44\uc6cc\uc9c4 \ud589\uc740 1, 3, 4\ubc88 \uc8fc\ubb38\uc774\ub77c \uacb0\uacfc\ub294 3<\/strong>\uc785\ub2c8\ub2e4. \ub2f4\ub2f9\uc790 \uc5f4\uc5d0 \uc4f0\uba74 \uc774\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ub2f4\ub2f9\uc790\uc785\ub825\uac74\uc218 = COUNT( \uc8fc\ubb38[\ub2f4\ub2f9\uc790] )<\/code><\/pre>\n\n
    \ube48 \uac12\uc774 \uc544\ub2cc \ud589\uc740 \uae40, \uc774, \uae40, \ubc15 \ub124 \uc904\uc774\ub77c 4<\/strong>\uc785\ub2c8\ub2e4. \ubb38\uc790\uc5f4 \uc5f4\uc5d0\ub3c4 \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ube48 \uac12\uacfc \ube48 \ubb38\uc790\uc5f4\uc740 \ub2e4\ub974\ub2e4<\/h2>\n\n
    DAX Guide\uc5d0 \ub530\ub974\uba74 COUNT\ub294 \ube48 \uac12\uc740 \uc138\uc9c0 \uc54a\uc9c0\ub9cc \ube48 \ubb38\uc790\uc5f4(“”)\uc740 \uc13c\ub2e4<\/strong>\uace0 \ud569\ub2c8\ub2e4. \ud654\uba74\uc5d0\uc11c\ub294 \ub458 \ub2e4 \ube44\uc5b4 \ubcf4\uc5ec\uc11c \uad6c\ubd84\uc774 \uc5b4\ub835\uc9c0\ub9cc, \uc6d0\ubcf8 \ub370\uc774\ud130\ub97c \uc5b4\ub5bb\uac8c \ubd88\ub7ec\uc654\ub290\ub0d0\uc5d0 \ub530\ub77c \ud55c\ucabd\uc73c\ub85c \ub4e4\uc5b4\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac1c\uc218\uac00 \uc608\uc0c1\ubcf4\ub2e4 \ub9ce\uc774 \ub098\uc624\uba74 \uc774 \ucc28\uc774\ub97c \uc758\uc2ec\ud574 \ubcfc \ub9cc\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \uc785\ub825 \uc644\uc131\ub3c4 \uc810\uac80<\/h2>\n\n
    \ub370\uc774\ud130\ub97c \ubc1b\uc558\uc744 \ub54c \uac00\uc7a5 \uba3c\uc800 \ud655\uc778\ud558\ub294 \uac83 \uc911 \ud558\ub098\uac00 “\ud544\uc218 \ud56d\ubaa9\uc774 \uc5bc\ub9c8\ub098 \ucc44\uc6cc\uc838 \uc788\ub294\uac00”\uc785\ub2c8\ub2e4. \ubc30\uc1a1\uc77c\uc774 \uc785\ub825\ub41c \ube44\uc728\uacfc \ube60\uc9c4 \uac74\uc218\ub97c \uad6c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ubc30\uc1a1\uc77c\uc785\ub825\ub960 =\nDIVIDE( COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] ), COUNTROWS( \uc8fc\ubb38 ) )\n\n\ubc30\uc1a1\uc77c\ubbf8\uc785\ub825\uac74\uc218 =\nCOUNTROWS( \uc8fc\ubb38 ) - COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] )<\/code><\/pre>\n\n
    \ubc30\uc1a1\uc77c\uc774 \uc788\ub294 \uc8fc\ubb38\uc740 3\uac74, \uc804\uccb4 \uc8fc\ubb38\uc740 5\uac74\uc774\ub2c8 \uc785\ub825\ub960\uc740 3 \u00f7 5 = 60%<\/strong>\uc774\uace0, \ubbf8\uc785\ub825\uc740 5 – 3 = 2\uac74<\/strong>(2\ubc88\uacfc 5\ubc88 \uc8fc\ubb38)\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c “\uc804\uccb4 \ud589 \uc218”\uc640 “\uac12\uc774 \uc788\ub294 \ud589 \uc218”\ub97c \ube44\uad50\ud558\ub294 \ubc29\uc2dd\uc740 \ub370\uc774\ud130 \ud488\uc9c8 \uc810\uac80\uc5d0 \uc790\uc8fc \uc4f0\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc804\uccb4 \ud589 \uc218\uc5d0\ub294 COUNTROWS\ub97c \uc4f0\ub294\ub370, \uc774\uc720\ub294 \ub4a4\uc5d0\uc11c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \uc870\uac74\uacfc \ud568\uaed8 \uc138\uae30<\/h2>\n\n
    “\uae40 \ub2f4\ub2f9\uc790\uac00 \ubc30\uc1a1\uae4c\uc9c0 \ub05d\ub0b8 \uac74\uc218”\ub294 CALCULATE\ub85c \uc870\uac74\uc744 \ubc14\uafd4\uc11c \uc149\ub2c8\ub2e4.<\/p>\n\n
    \uae40\ub2f4\ub2f9\ubc30\uc1a1\uac74\uc218 =\nCALCULATE(\n    COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] ),\n    \uc8fc\ubb38[\ub2f4\ub2f9\uc790] = \"\uae40\"\n)<\/code><\/pre>\n\n
    \ub2f4\ub2f9\uc790\uac00 \uae40\uc778 \ud589\uc740 1\ubc88, 4\ubc88\uc774\uace0 \ub458 \ub2e4 \ubc30\uc1a1\uc77c\uc774 \uc788\uc5b4\uc11c 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.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \uc2dd\uc758 \uacb0\uacfc\ub97c \uc138\uae30 (COUNTX)<\/h2>\n\n
    COUNT\ub294 \uc5f4 \ud558\ub098\ub9cc \ubc1b\uc2b5\ub2c8\ub2e4. “\uae08\uc561\uc774 30 \uc774\uc0c1\uc778 \uc8fc\ubb38 \uc218”\ucc98\ub7fc \uc870\uac74\uc2dd\uc758 \uacb0\uacfc\ub97c \uc138\ub824\uba74 COUNTX\ub97c \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. DAX Guide\uc5d0 \ub530\ub974\uba74 COUNTX\ub294 \ud14c\uc774\ube14\uc758 \uac01 \ud589\uc5d0\uc11c \uc2dd\uc744 \uacc4\uc0b0\ud558\uace0, \ube48 \uac12\uc774 \uc544\ub2cc \uacb0\uacfc\uc758 \uac1c\uc218<\/strong>\ub97c \uc149\ub2c8\ub2e4. \uc774 \uc131\uc9c8\uc744 \uc774\uc6a9\ud558\uba74 \uc774\ub807\uac8c \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ud070\uc8fc\ubb38\uac74\uc218_X =\nCOUNTX(\n    \uc8fc\ubb38,\n    IF( \uc8fc\ubb38[\uae08\uc561] >= 30, 1 )\n)<\/code><\/pre>\n\n
    IF\uc5d0 else \uac12\uc744 \uc8fc\uc9c0 \uc54a\uc73c\uba74 \uc870\uac74\uc774 \uac70\uc9d3\uc77c \ub54c \ube48 \uac12\uc774 \ub098\uc635\ub2c8\ub2e4. \uadf8\ub798\uc11c \uae08\uc561\uc774 30 \uc774\uc0c1\uc778 1\ubc88(30), 3\ubc88(50), 5\ubc88(40)\ub9cc 1\uc744 \ub3cc\ub824\uc8fc\uace0 \ub098\uba38\uc9c0\ub294 \ube48 \uac12\uc774 \ub418\uc5b4, \uacb0\uacfc\ub294 3<\/strong>\uc785\ub2c8\ub2e4. \ub2e4\ub9cc \uac19\uc740 \uacb0\uacfc\ub97c \ub354 \uc9c1\uad00\uc801\uc73c\ub85c \uc5bb\ub294 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ud070\uc8fc\ubb38\uac74\uc218 =\nCOUNTROWS( FILTER( \uc8fc\ubb38, \uc8fc\ubb38[\uae08\uc561] >= 30 ) )<\/code><\/pre>\n\n
    \uc774\ucabd\uc774 “\uc870\uac74\uc5d0 \ub9de\ub294 \ud589\uc758 \uc218”\ub77c\ub294 \uc758\ub3c4\uac00 \ubc14\ub85c \uc77d\ud799\ub2c8\ub2e4. COUNTX\ub294 \uc13c \uac12\uc774 “\uc2dd\uc758 \uacb0\uacfc”\uc77c \ub54c, \uc608\ub97c \ub4e4\uc5b4 \uacc4\uc0b0\ud55c \uac12\uc774 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \uacbd\uc6b0\ub9cc \uc138\uace0 \uc2f6\uc744 \ub54c \uc4f0\ub294 \ud3b8\uc774 \uc790\uc5f0\uc2a4\ub7fd\uc2b5\ub2c8\ub2e4. DAX Guide\ub294 COUNT\uac00 \uc5f4 \ud558\ub098\uc5d0 \uc4f4 COUNTX\uc758 \uc904\uc784 \ud45c\ud604\uc774\ub77c\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \uc989 COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] )<\/code>\uacfc COUNTX( \uc8fc\ubb38, \uc8fc\ubb38[\ubc30\uc1a1\uc77c] )<\/code>\uc740 \uac19\uc740 \uacb0\uacfc(3)\ub97c \ub0c5\ub2c8\ub2e4.<\/p>\n\n
    TRUE\/FALSE \uc5f4\uc740 COUNTA\ub85c<\/h2>\n\n
    \uc2b9\uc778 \uc5f4\ucc98\ub7fc \ucc38\/\uac70\uc9d3\uc774 \ub4e4\uc5b4 \uc788\ub294 \uc5f4\uc740 COUNT\uac00 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4\uace0 Microsoft \ubb38\uc11c\uac00 \uc548\ub0b4\ud569\ub2c8\ub2e4. \uc774\ub7f4 \ub54c\ub294 COUNTA\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n
    \uc2b9\uc778\uc5f4\uac12\uac1c\uc218 = COUNTA( \uc8fc\ubb38[\uc2b9\uc778] )<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 5\uc785\ub2c8\ub2e4. \ubaa8\ub4e0 \ud589\uc5d0 TRUE\ub098 FALSE\uac00 \ub4e4\uc5b4 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc774 5\ub294 “\uc2b9\uc778\ub41c \uac74\uc218”\uac00 \uc544\ub2c8\ub77c “\uc2b9\uc778 \uc5ec\ubd80\uac00 \uae30\ub85d\ub41c \ud589 \uc218”\ub77c\ub294 \uc810\uc5d0 \uc8fc\uc758\ud558\uc138\uc694. \ucc38\uc778 \ud589\ub9cc \uc138\uace0 \uc2f6\ub2e4\uba74 \uc870\uac74\uc744 \uac78\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc2b9\uc778\uac74\uc218 =\nCALCULATE(\n    COUNTROWS( \uc8fc\ubb38 ),\n    \uc8fc\ubb38[\uc2b9\uc778] = TRUE()\n)<\/code><\/pre>\n\n
    1, 3, 4\ubc88\uc774 \ucc38\uc774\ub77c \uacb0\uacfc\ub294 3<\/strong>\uc785\ub2c8\ub2e4. COUNTX\uc640 COUNTAX\uc758 \uad00\uacc4\ub3c4 \uac19\uc2b5\ub2c8\ub2e4. DAX Guide\uc5d0 \ub530\ub974\uba74 COUNTAX\ub294 \ucc38\/\uac70\uc9d3\ub3c4 \ucc98\ub9ac\ud558\uace0 COUNTX\ub294 \ucc98\ub9ac\ud558\uc9c0 \ubabb\ud569\ub2c8\ub2e4. COUNTA\ub294 \ubcc4\ub3c4 \uae00\uc5d0\uc11c \uc790\uc138\ud788 \ub2e4\ub8f9\ub2c8\ub2e4.<\/p>\n\n
    COUNT, COUNTA, COUNTROWS \uad6c\ubd84\ud558\uae30<\/h2>\n\n\n\n
    \ud568\uc218<\/th>\ubb34\uc5c7\uc744 \uc138\ub098<\/th>\uc608\uc81c \uacb0\uacfc<\/th><\/tr><\/thead>\n
    COUNT( \uc5f4 )<\/td>\uac12\uc774 \uc788\ub294 \ud589(\uc22b\uc790, \ub0a0\uc9dc, \ubb38\uc790\uc5f4). \ucc38\/\uac70\uc9d3 \uc5f4\uc740 \ubd88\uac00<\/td>\ubc30\uc1a1\uc77c 3<\/td><\/tr>\n
    COUNTA( \uc5f4 )<\/td>\uac12\uc774 \uc788\ub294 \ud589. \ucc38\/\uac70\uc9d3\ub3c4 \uac00\ub2a5<\/td>\uc2b9\uc778 5<\/td><\/tr>\n
    COUNTROWS( \ud14c\uc774\ube14 )<\/td>\ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ud589(\uac12\uc774 \ube44\uc5b4 \uc788\uc5b4\ub3c4 \uc13c\ub2e4)<\/td>5<\/td><\/tr>\n
    COUNTX( \ud14c\uc774\ube14, \uc2dd )<\/td>\ud589\ub9c8\ub2e4 \uacc4\uc0b0\ud55c \uc2dd\uc758 \uacb0\uacfc \uc911 \ube48 \uac12\uc774 \uc544\ub2cc \uac83<\/td>\ud070 \uc8fc\ubb38 3<\/td><\/tr>\n
    DISTINCTCOUNT( \uc5f4 )<\/td>\uc11c\ub85c \ub2e4\ub978 \uac12\uc758 \uac1c\uc218. \ube48 \uac12 \ucc98\ub9ac\uac00 \ub530\ub85c \uc788\uc5b4\uc11c \ubcc4\ub3c4 \uae00\uc5d0\uc11c \ub2e4\ub8f8<\/td>–<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    DAX Guide\ub294 \uc22b\uc790\ub098 \ub0a0\uc9dc, \ubb38\uc790\uc5f4 \uc5f4\uc5d0\uc11c\ub294 COUNT\uc640 COUNTA\uac00 \uac19\uc740 \uacb0\uacfc\ub97c \ub0b8\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \ub2ec\ub77c\uc9c0\ub294 \uc9c0\uc810\uc740 \ucc38\/\uac70\uc9d3 \uc5f4\ubfd0\uc785\ub2c8\ub2e4.<\/p>\n\n
    \ud589 \uc218\ub97c \uc138\ub824\uba74 COUNTROWS\ub97c \uc4f0\ub77c\ub294 \uad8c\uace0<\/h2>\n\n
    Microsoft \ubb38\uc11c\uc5d0\ub294 “COUNT \ub300\uc2e0 COUNTROWS\ub97c \uc4f0\ub77c”\ub294 \ubaa8\ubc94 \uc0ac\ub840 \ubb38\uc11c\uac00 \ub530\ub85c \uc788\uc2b5\ub2c8\ub2e4. \ub450 \ud568\uc218\ub294 \uc138\ub294 \uc5f4\uc5d0 \ube48 \uac12\uc774 \uc5c6\uc73c\uba74 \uac19\uc740 \uacb0\uacfc\ub97c \ub0b4\uc9c0\ub9cc, \ubb38\uc11c\ub294 \ud14c\uc774\ube14\uc758 \ud589 \uc218\ub97c \uc138\ub294 \uac83\uc774 \ubaa9\uc801\uc774\ub77c\uba74 COUNTROWS\ub97c \uc4f0\ub77c\uace0 \uad8c\ud569\ub2c8\ub2e4. \uc774\uc720\ub294 \uc138 \uac00\uc9c0\ub85c \uc815\ub9ac\ub429\ub2c8\ub2e4.<\/p>\n\n
      \n
    • \ub354 \ud6a8\uc728\uc801\uc774\ub77c\uc11c \uc131\ub2a5\uc774 \ub0ab\ub2e4<\/li>\n
    • \ud14c\uc774\ube14\uc758 \uc5b4\ub5a4 \uc5f4\uc5d0 \ube48 \uac12\uc774 \uc788\uc5b4\ub3c4 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\ub294\ub2e4<\/li>\n
    • \uc2dd\uc758 \uc758\ub3c4\uac00 \ubd84\uba85\ud574\uc11c \uc77d\ub294 \uc21c\uac04 \ubb34\uc2a8 \ub73b\uc778\uc9c0 \uc54c \uc218 \uc788\ub2e4<\/li>\n<\/ul>\n\n
      \ucd1d\uc8fc\ubb38\uac74\uc218 = COUNTROWS( \uc8fc\ubb38 )   -- 5\n\ubc30\uc1a1\uc785\ub825\uac74\uc218 = COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] ) -- 3<\/code><\/pre>\n\n
      \ub450 \uac12\uc758 \ucc28\uc774\uac00 “\ubc30\uc1a1\uc77c\uc774 \ube44\uc5b4 \uc788\ub294 \uc8fc\ubb38 \uc218”\uc785\ub2c8\ub2e4. \uc2dc\ub098\ub9ac\uc624 1\uc5d0\uc11c \uc804\uccb4 \ud589 \uc218 \uc790\ub9ac\uc5d0 COUNTROWS\ub97c \uc4f4 \uc774\uc720\uac00 \uc774\uac83\uc785\ub2c8\ub2e4. \ub9cc\uc57d \uc804\uccb4 \ud589 \uc218\ub97c \uad6c\ud558\ub824\uace0 \ub2f4\ub2f9\uc790 \uc5f4\uc5d0 COUNT\ub97c \uc37c\ub2e4\uba74 4\uac00 \ub098\uc640\uc11c \uc785\ub825\ub960\uc774 3 \u00f7 4 = 75%\ub85c \uc798\ubabb \uacc4\uc0b0\ub410\uc744 \uac83\uc785\ub2c8\ub2e4. SQLBI\uc758 DAX \ud568\uc218 \uc18c\uac1c \uc601\uc0c1 \ud398\uc774\uc9c0\ub3c4 COUNT\ub294 \ube48 \uac12\uc744 \uac74\ub108\ub6f0\ub294 \ud568\uc218\ub77c\uace0 \uc124\uba85\ud558\uba70, \uc2dd \uae30\ubc18\uc73c\ub85c \uc138\ub824\uba74 COUNTX \uacc4\uc5f4\uc744 \uc4f4\ub2e4\uace0 \uad6c\ubd84\ud569\ub2c8\ub2e4.<\/p>\n\n
      \ub0b4\ubd80 \ub3d9\uc791<\/h2>\n\n
      DAX Guide\uc5d0 \ub530\ub974\uba74 COUNT\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c COUNTX\ub97c \uc2e4\ud589\ud558\ub294 \uac83\uacfc \uac19\uace0 \uc131\ub2a5 \ucc28\uc774\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \uac19\uc740 \ub73b\uc744 \uc544\ub798\ucc98\ub7fc \ud480\uc5b4 \uc4f8 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
      CALCULATE( COUNTROWS( \uc8fc\ubb38 ), NOT ISBLANK( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] ) )<\/code><\/pre>\n\n
      \ub450 \uc2dd \ubaa8\ub450 \ubc30\uc1a1\uc77c\uc774 \ube44\uc5b4 \uc788\uc9c0 \uc54a\uc740 \ud589\uc758 \uc218\ub97c \uad6c\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\/\uac70\uc9d3 \uc5f4\uc744 \uc140 \ub54c<\/strong>: COUNT\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. COUNTA\ub97c \uc4f0\uc138\uc694.<\/li>\n
      • \uc11c\ub85c \ub2e4\ub978 \uac12\uc758 \uc218\uac00 \ud544\uc694\ud560 \ub54c<\/strong>: COUNT\ub294 \uc911\ubcf5\ub3c4 \ubaa8\ub450 \uc149\ub2c8\ub2e4. DISTINCTCOUNT\uac00 \ub9de\uc2b5\ub2c8\ub2e4.<\/li>\n
      • “\ucc38\uc778 \uac74\uc218”\uac00 \ud544\uc694\ud560 \ub54c<\/strong>: \uc5f4\uc5d0 \uac12\uc774 \uc788\ub294 \ud589\uc744 \uc138\ub294 \uac83\uc774\ubbc0\ub85c \uc870\uac74\uc744 \uac78\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n
        \uc54c\uc544\ub458 \uc810<\/h2>\n\n
          \n
        • COUNT\uc758 \uc778\uc218\ub294 \uc5f4 \ud558\ub098\ubfd0\uc785\ub2c8\ub2e4. \ud14c\uc774\ube14\uc744 \ub123\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n
        • \uc13c \ud589\uc774 \uc5c6\uc73c\uba74 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12\uc774 \ub098\uc635\ub2c8\ub2e4. \ud45c\uc5d0 0\uc73c\ub85c \ubcf4\uc774\uac8c \ud558\uace0 \uc2f6\ub2e4\uba74 \ubcc4\ub3c4 \ucc98\ub9ac\uac00 \ud544\uc694\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\uc5d0 COUNT<\/strong>: \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \ud615\uc2dd\uc785\ub2c8\ub2e4. COUNTA\ub098 \uc870\uac74\uc744 \uac74 COUNTROWS\ub97c \uc4f0\uc138\uc694.<\/li>\n
          2. \ud589 \uc218\ub97c \uc138\ub824\uace0 \uc544\ubb34 \uc5f4\uc774\ub098 COUNT<\/strong>: \uadf8 \uc5f4\uc774 \ube44\uc5b4 \uc788\ub294 \ud589\uc740 \ube60\uc9d1\ub2c8\ub2e4. \uc804\uccb4 \ud589 \uc218\ub294 COUNTROWS\uc785\ub2c8\ub2e4.<\/li>\n
          3. \ube48 \uac12\uacfc \ube48 \ubb38\uc790\uc5f4\uc744 \uac19\ub2e4\uace0 \uc0dd\uac01<\/strong>: COUNT\ub294 \ub458\uc744 \ub2e4\ub974\uac8c \ucde8\uae09\ud569\ub2c8\ub2e4.<\/li>\n
          4. \uc911\ubcf5 \uac12\uc744 \uace0\ub824\ud558\uc9c0 \uc54a\uace0 “\uace0\uac1d \uc218”\ub97c COUNT\ub85c \uacc4\uc0b0<\/strong>: \uac19\uc740 \uace0\uac1d\uc774 \uc5ec\ub7ec \ud589\uc5d0 \uc788\uc73c\uba74 \ud589 \uc218\ub9cc\ud07c \uc138\uc5b4\uc9d1\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n
            \uc815\ub9ac<\/h2>\n\n
            COUNT\ub294 “\uadf8 \uc5f4\uc5d0 \uac12\uc774 \ub4e4\uc5b4 \uc788\ub294 \ud589”\uc744 \uc138\uace0, \ud14c\uc774\ube14\uc758 \uc804\uccb4 \ud589\uc740 COUNTROWS, \ucc38\/\uac70\uc9d3 \uc5f4\uc740 COUNTA, \uc2dd\uc758 \uacb0\uacfc\ub294 COUNTX, \uc11c\ub85c \ub2e4\ub978 \uac12\uc758 \uc218\ub294 DISTINCTCOUNT\ub85c \ub098\ub220 \uc4f0\uba74 \ub429\ub2c8\ub2e4. \uac00\uc7a5 \ud754\ud55c \uc2e4\uc218\ub294 \ud589 \uc218\ub97c \uc138\ub824\uace0 \uc544\ubb34 \uc5f4\uc5d0\ub098 COUNT\ub97c \uc4f0\ub294 \uac83\uc774\ub2c8, \uc9c8\ubb38\uc774 “\ud589\uc774 \uba87 \uac1c\uc778\uac00”\uc778\uc9c0 “\uac12\uc774 \uc785\ub825\ub41c \ud589\uc774 \uba87 \uac1c\uc778\uac00”\uc778\uc9c0\ubd80\ud130 \uad6c\ubd84\ud574 \ubcf4\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, COUNT function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/count-function-dax<\/li>\n
            • Microsoft Learn, Use COUNTROWS instead of COUNT in DAX: https:\/\/learn.microsoft.com\/en-us\/dax\/best-practices\/dax-countrows<\/li>\n
            • Microsoft Learn, Aggregation functions (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/aggregation-functions-dax<\/li>\n
            • DAX Guide, COUNT: https:\/\/dax.guide\/count\/<\/li>\n
            • DAX Guide, COUNTX: https:\/\/dax.guide\/countx\/<\/li>\n
            • SQLBI, COUNT, COUNTA, COUNTAX, COUNTX: https:\/\/www.sqlbi.com\/tv\/count-counta-countax-countx-dax-guide\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
              DAX COUNT \ud568\uc218\uc758 \ub3d9\uc791, \ube48 \uac12\uacfc \ube48 \ubb38\uc790\uc5f4, \uc785\ub825\ub960 \uc810\uac80\u00b7\uc870\uac74\ubd80 \uac1c\uc218\u00b7COUNTX \uc2dc\ub098\ub9ac\uc624, COUNTA\u00b7COUNTROWS\uc640\uc758 \ucc28\uc774\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":[10,4,6],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-count","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\/25","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=25"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":32,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/25\/revisions\/32"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}