{"id":28,"date":"2026-10-05T10:10:08","date_gmt":"2026-10-05T01:10:08","guid":{"rendered":"https:\/\/vera-b.com\/?p=28"},"modified":"2026-10-05T10:10:08","modified_gmt":"2026-10-05T01:10:08","slug":"dax-countrows-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ed%96%89-%ec%88%98%eb%a5%bc-%ec%85%80-%eb%95%8c-count%eb%b3%b4%eb%8b%a4-%eb%a8%bc%ec%a0%80-%eb%96%a0%ec%98%ac%eb%a6%b4-%ed%95%a8%ec%88%98","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=28","title":{"rendered":"DAX COUNTROWS \ud568\uc218 \uc815\ub9ac: \ud589 \uc218\ub97c \uc140 \ub54c COUNT\ubcf4\ub2e4 \uba3c\uc800 \ub5a0\uc62c\ub9b4 \ud568\uc218"},"content":{"rendered":"\n

“\uc8fc\ubb38\uc774 \uba87 \uac74\uc774\uc9c0?”\ub97c \uacc4\uc0b0\ud560 \ub54c \uc5f4 \ud558\ub098\ub97c \uace8\ub77c COUNT\ub97c \uc4f0\ub294 \uc0ac\ub78c\uc774 \ub9ce\uc2b5\ub2c8\ub2e4. \ud2c0\ub9b0 \ubc29\ubc95\uc740 \uc544\ub2cc\ub370, Microsoft \ubb38\uc11c\uc5d0\ub294 \uc774\ub7f0 \uc0c1\ud669\uc5d0\uc11c COUNTROWS\ub97c \uc4f0\ub77c\ub294 \uad8c\uace0\uac00 \ub530\ub85c \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 COUNTROWS\uac00 \uc5b4\ub5a4 \ud568\uc218\uc778\uc9c0, \uc65c \uad8c\uc7a5\ub418\ub294\uc9c0, \uadf8\ub9ac\uace0 \ud544\ud130, \uad00\uacc4, \uace0\uc720 \uac12 \uc138\uae30\uc640 \ud568\uaed8 \uc4f0\ub294 \ub300\ud45c \ud328\ud134\uc744 \uac19\uc740 \ub370\uc774\ud130\ub85c \uc815\ub9ac\ud569\ub2c8\ub2e4. \uc55e\uc11c \uc4f4 COUNT \ud568\uc218 \uae00<\/a>\uacfc COUNTA \ud568\uc218 \uae00<\/a>\uc758 \ub2e4\uc74c \uc774\uc57c\uae30\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4.<\/p>\n\n

\ubb38\ubc95<\/h2>\n\n
COUNTROWS( [<\ud14c\uc774\ube14>] )<\/code><\/pre>\n\n
\uc778\uc218\ub294 \ud14c\uc774\ube14 \ud558\ub098<\/strong>\uc774\uace0, \uadf8 \ud14c\uc774\ube14\uc758 \ud589 \uc218\ub97c \uc815\uc218\ub85c \ub3cc\ub824\uc90d\ub2c8\ub2e4. \uc778\uc218\ub294 \ubaa8\ub378\uc5d0 \uc788\ub294 \ud14c\uc774\ube14 \uc774\ub984\uc77c \uc218\ub3c4 \uc788\uace0, \ud14c\uc774\ube14\uc744 \ub3cc\ub824\uc8fc\ub294 \uc2dd\uc77c \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \ub300\uad04\ud638\ub85c \ud45c\uc2dc\ud588\ub4ef \uc778\uc218\ub97c \uc0dd\ub7b5\ud560 \uc218\ub3c4 \uc788\ub294\ub370, \uadf8\ub7ec\uba74 \uc2dd\uc774 \uc18d\ud55c \ud14c\uc774\ube14\uc774 \uae30\ubcf8\uac12\uc73c\ub85c \uc4f0\uc785\ub2c8\ub2e4(Microsoft \ubb38\uc11c). DAX Guide\ub294 \uc0dd\ub7b5\uc774 \uac00\ub2a5\ud574\ub3c4 \ud14c\uc774\ube14\uc744 \uba85\uc2dc\ud558\ub294 \ucabd\uc774 \uc77d\uae30 \uc88b\uace0 \uad00\ub9ac\ud558\uae30 \uc27d\ub2e4\uace0 \uad8c\ud569\ub2c8\ub2e4. \uc13c \uacb0\uacfc\uac00 0\ud589\uc774\uba74 0\uc774 \uc544\ub2c8\ub77c \ube48 \uac12(BLANK)\uc774 \ubc18\ud658\ub429\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 \ucd1d\uc8fc\ubb38\uac74\uc218 = COUNTROWS( \uc8fc\ubb38 )<\/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\ud569\ub2c8\ub2e4. \uace0\uac1d \uac19\uc740 \uc5f4\uacfc \ud568\uaed8 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \uc904\ub9c8\ub2e4 \uac12\uc774 \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. \uacb0\uacfc\ub294 Power BI\uc5d0\uc11c \ub3cc\ub9b0 \ud654\uba74\uc774 \uc544\ub2c8\ub77c \uc9c1\uc811 \uc13c \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
    \uace0\uac1d<\/th><\/tr>
    \uace0\uac1dID<\/th>\uc774\ub984<\/th><\/tr><\/thead>\n
    A<\/td>\uae40<\/td><\/tr>\n
    B<\/td>\uc774<\/td><\/tr>\n
    C<\/td>\ubc15<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
    \uc8fc\ubb38<\/th><\/tr>
    \uc8fc\ubb38<\/th>\uace0\uac1dID<\/th>\uae08\uc561<\/th>\ubc30\uc1a1\uc77c<\/th><\/tr><\/thead>\n
    1<\/td>A<\/td>30<\/td>3\/2<\/td><\/tr>\n
    2<\/td>A<\/td>20<\/td>3\/3<\/td><\/tr>\n
    3<\/td>B<\/td>50<\/td>(\ube48 \uac12)<\/td><\/tr>\n
    4<\/td>A<\/td>10<\/td>3\/5<\/td><\/tr>\n
    5<\/td>B<\/td>40<\/td>3\/6<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uae30\ubcf8: \ud14c\uc774\ube14\uc758 \ud589 \uc218<\/h2>\n\n
    \ucd1d\uc8fc\ubb38\uac74\uc218 = COUNTROWS( \uc8fc\ubb38 )<\/code><\/pre>\n\n
    \uc8fc\ubb38 \ud45c\uc5d0\ub294 5\ud589\uc774 \uc788\uc73c\ub2c8 \uacb0\uacfc\ub294 5<\/strong>\uc785\ub2c8\ub2e4. \uace0\uac1d\ubcc4 \ud45c\uc5d0 \uc62c\ub9ac\uba74 \ud544\ud130\uac00 \uc801\uc6a9\ub418\uc5b4 \uae40 3, \uc774 2\ub85c \ub098\ub269\ub2c8\ub2e4. \uc774 \uce21\uc815\uac12\uc740 \ubcf4\uace0\uc11c\uc758 \uac01 \uc140\uc774 \uac00\uc9c4 \ud544\ud130 \uc0c1\ud0dc\uc5d0 \ub9de\ucdb0 \ub2e4\uc2dc \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/p>\n\n
    \uc65c COUNT \ub300\uc2e0 COUNTROWS\uc778\uac00<\/h2>\n\n
    \uac19\uc740 \uac12\uc744 \uc5f4 \ud558\ub098\ub85c \uc140 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ubc30\uc1a1\uc785\ub825\uac74\uc218 = COUNT( \uc8fc\ubb38[\ubc30\uc1a1\uc77c] )   -- 4\n\ucd1d\uc8fc\ubb38\uac74\uc218   = COUNTROWS( \uc8fc\ubb38 )         -- 5<\/code><\/pre>\n\n
    \ubc30\uc1a1\uc77c \uc5f4\uc5d0\ub294 \ube48 \uac12\uc774 \ud558\ub098 \uc788\uc5b4\uc11c COUNT\ub294 4, COUNTROWS\ub294 5\uc785\ub2c8\ub2e4. \ub458\uc774 \uac19\uc740 \uac12\uc744 \ub0b4\ub294 \uacbd\uc6b0\ub294 “\uc138\ub294 \uc5f4\uc5d0 \ube48 \uac12\uc774 \uc5c6\uc744 \ub54c”\ubfd0\uc774\ub77c\ub294 \uac83\uc774 Microsoft \ubb38\uc11c\uc758 \uc124\uba85\uc785\ub2c8\ub2e4. \uadf8\ub798\uc11c \ubb38\uc11c\ub294 \ud14c\uc774\ube14\uc758 \ud589 \uc218\ub97c \uc138\ub824\ub294 \uc758\ub3c4\ub77c\uba74 \ud56d\uc0c1 COUNTROWS\ub97c \uc4f0\ub77c\uace0 \uad8c\ud558\uba70, \uc774\uc720\ub97c \uc138 \uac00\uc9c0\ub85c \ub4ed\ub2c8\ub2e4.<\/p>\n\n