{"id":29,"date":"2026-10-06T07:57:22","date_gmt":"2026-10-05T22:57:22","guid":{"rendered":"https:\/\/vera-b.com\/?p=29"},"modified":"2026-10-06T07:57:22","modified_gmt":"2026-10-05T22:57:22","slug":"dax-distinctcount-%ed%95%a8%ec%88%98-%ec%a0%95%eb%a6%ac-%ea%b3%a0%ec%9c%a0-%ea%b0%92-%ea%b0%9c%ec%88%98%ec%99%80-%ed%95%a9%ea%b3%84%ea%b0%80-%ec%95%88-%eb%a7%9e%eb%8a%94-%ec%9d%b4%ec%9c%a0","status":"publish","type":"post","link":"https:\/\/vera-b.com\/?p=29","title":{"rendered":"DAX DISTINCTCOUNT \ud568\uc218 \uc815\ub9ac: \uace0\uc720 \uac12 \uac1c\uc218\uc640 \ud569\uacc4\uac00 \uc548 \ub9de\ub294 \uc774\uc720"},"content":{"rendered":"\n

“\uc6b0\ub9ac \uac00\uac8c\uc5d0 \uc628 \uace0\uac1d\uc774 \uba87 \uba85\uc774\uc9c0?”\ub77c\uace0 \ubb3c\uc73c\uba74 \uc8fc\ubb38 \uac74\uc218\uc640\ub294 \ub2e4\ub978 \ub2f5\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \ud55c \uc0ac\ub78c\uc774 \uc5ec\ub7ec \ubc88 \uc8fc\ubb38\ud588\uc744 \uc218 \uc788\uc73c\ub2c8\uae4c\uc694. \uc774\ub7f4 \ub54c \uc4f0\ub294 \ud568\uc218\uac00 DISTINCTCOUNT\uc785\ub2c8\ub2e4. \ubb38\ubc95\uc740 \ub2e8\uc21c\ud55c\ub370, \ube48 \uac12\uc744 \ud55c \uac1c\uc758 \uac12\uc73c\ub85c \uc13c\ub2e4\ub294 \uc810\uacfc \ud569\uacc4 \uc904\uc774 \uac01 \uc904\uc758 \ud569\uacfc \ub9de\uc9c0 \uc54a\ub294\ub2e4\ub294 \uc810 \ub54c\ubb38\uc5d0 \ucc98\uc74c\uc5d0\ub294 \uc790\uc8fc \ub2f9\ud669\ud569\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \uadf8 \ub450 \uac00\uc9c0\ub97c \uc911\uc2ec\uc73c\ub85c, \uc55e\uc11c \uc815\ub9ac\ud55c COUNT<\/a>, COUNTA<\/a>, COUNTROWS<\/a>\uc640 \uc5b4\ub514\uc11c \uac08\ub9ac\ub294\uc9c0, \uadf8\ub9ac\uace0 \uc2e4\ubb34\uc5d0\uc11c \uc790\uc8fc \uc4f0\ub294 \uc138 \uac00\uc9c0 \uc0c1\ud669(\uace0\uac1d \uc218, \uc6d4\ubcc4 \ud65c\uc131 \uace0\uac1d, \uace0\uac1d\ub2f9 \ud3c9\uade0 \uc8fc\ubb38 \uc218)\uc744 \uac19\uc740 \ub370\uc774\ud130\ub85c \uc815\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n

\ubb38\ubc95<\/h2>\n\n
DISTINCTCOUNT( <\uc5f4> )<\/code><\/pre>\n\n
\uc5f4 \ud558\ub098\ub97c \ubc1b\uc544\uc11c \uc11c\ub85c \ub2e4\ub978 \uac12\uc774 \uba87 \uac1c\uc778\uc9c0<\/strong>\ub97c \ub3cc\ub824\uc90d\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc5d0 \ub530\ub974\uba74 \uc5f4\uc758 \ub370\uc774\ud130 \ud615\uc2dd\uc740 \uc5b4\ub5a4 \uac83\uc774\ub4e0 \uc0c1\uad00\uc5c6\uc2b5\ub2c8\ub2e4. \uc140 \ud589\uc774 \ud558\ub098\ub3c4 \uc5c6\uc73c\uba74 \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 \uace0\uac1d\uc218 = DISTINCTCOUNT( \uc8fc\ubb38[\uace0\uac1d] )<\/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\ub9ac\uace0, \uc6d4\uc774\ub098 \ubd84\ub958 \uac19\uc740 \uc5f4\uacfc \ud568\uaed8 \ud45c\uc5d0 \uc62c\ub824 \ud569\uacc4 \uc904\uc774 \uc5b4\ub5bb\uac8c \ub098\uc624\ub294\uc9c0 \ud655\uc778\ud569\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. 5\ubc88 \uc8fc\ubb38\uc740 \uace0\uac1d \uc815\ubcf4\uac00 \ube44\uc5b4 \uc788\uc2b5\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
    \uc8fc\ubb38<\/th>\uc6d4<\/th>\uace0\uac1d<\/th>\ubd84\ub958<\/th><\/tr><\/thead>\n
    1<\/td>3\uc6d4<\/td>\uae40<\/td>\ub178\ud2b8\ubd81<\/td><\/tr>\n
    2<\/td>3\uc6d4<\/td>\uae40<\/td>\ub9c8\uc6b0\uc2a4<\/td><\/tr>\n
    3<\/td>3\uc6d4<\/td>\uc774<\/td>\ub178\ud2b8\ubd81<\/td><\/tr>\n
    4<\/td>4\uc6d4<\/td>\ubc15<\/td>\ub9c8\uc6b0\uc2a4<\/td><\/tr>\n
    5<\/td>4\uc6d4<\/td>(\ube48 \uac12)<\/td>\ubaa8\ub2c8\ud130<\/td><\/tr>\n
    6<\/td>4\uc6d4<\/td>\uc774<\/td>\ub9c8\uc6b0\uc2a4<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc8fc\ubb38\uc740 \ubaa8\ub450 6\uac74\uc774\ub2c8 COUNTROWS( \uc8fc\ubb38 )\uc740 6\uc785\ub2c8\ub2e4. \uace0\uac1d \uc5f4\uc5d0 \uac12\uc774 \uc788\ub294 \ud589\uc740 5\uac1c\ub77c\uc11c COUNT( \uc8fc\ubb38[\uace0\uac1d] )\uc740 5\uc785\ub2c8\ub2e4. \uadf8\ub807\ub2e4\uba74 \uace0\uac1d\uc740 \uba87 \uba85\uc77c\uae4c\uc694?<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 1: \uace0\uac1d \uc218, \uadf8\ub9ac\uace0 \ube48 \uac12\ub3c4 \ud558\ub098\uc758 \uac12\uc73c\ub85c \uc13c\ub2e4<\/h2>\n\n
    \uace0\uac1d\uc218 = DISTINCTCOUNT( \uc8fc\ubb38[\uace0\uac1d] )<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 4<\/strong>\uc785\ub2c8\ub2e4. \uae40, \uc774, \ubc15 \uc138 \uba85\uc5d0 \ube48 \uac12\uc774 \ud558\ub098 \ub354\ud574\uc84c\uc2b5\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc640 DAX Guide \ubaa8\ub450 DISTINCTCOUNT\uac00 BLANK\ub97c \ud558\ub098\uc758 \uac12\uc73c\ub85c \uc13c\ub2e4\uace0 \uc124\uba85\ud569\ub2c8\ub2e4. \uc0ac\ub78c\uc774 \uc138 \uba85\uc778\ub370 4\uac00 \ub098\uc624\ub294 \uc774\uc720\uac00 \uc774\uac83\uc785\ub2c8\ub2e4. \ube48 \uac12\uc744 \ube7c\uace0 \uc138\uace0 \uc2f6\ub2e4\uba74 DISTINCTCOUNTNOBLANK\ub97c \uc501\ub2c8\ub2e4.<\/p>\n\n
    \uace0\uac1d\uc218_\ube48\uac12\uc81c\uc678 = DISTINCTCOUNTNOBLANK( \uc8fc\ubb38[\uace0\uac1d] )<\/code><\/pre>\n\n
    \uacb0\uacfc\ub294 3<\/strong>\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\uc758 \uc608\uc81c\ub3c4 \uac19\uc740 \uad6c\uc870\ub85c, \uc885\ub8cc\uc77c \uc5f4\uc5d0\uc11c DISTINCTCOUNTNOBLANK\ub294 2, DISTINCTCOUNT\ub294 3\uc774 \ub098\uc624\ub294 \uac83\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. \ub458 \uc0ac\uc774\uc758 \ucc28\uc774\uac00 \ubc14\ub85c \ube48 \uac12 \ud558\ub098\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n
    \ud568\uc218<\/th>\uc9c8\ubb38<\/th>\uc608\uc81c \uacb0\uacfc<\/th><\/tr><\/thead>\n
    COUNTROWS( \uc8fc\ubb38 )<\/td>\uc8fc\ubb38\uc774 \uba87 \uac74\uc778\uac00<\/td>6<\/td><\/tr>\n
    COUNT( \uc8fc\ubb38[\uace0\uac1d] )<\/td>\uace0\uac1d\uc774 \uc801\ud78c \uc8fc\ubb38\uc774 \uba87 \uac74\uc778\uac00<\/td>5<\/td><\/tr>\n
    DISTINCTCOUNT( \uc8fc\ubb38[\uace0\uac1d] )<\/td>\uc11c\ub85c \ub2e4\ub978 \uace0\uac1d \uac12\uc774 \uba87 \uac1c\uc778\uac00(\ube48 \uac12 \ud3ec\ud568)<\/td>4<\/td><\/tr>\n
    DISTINCTCOUNTNOBLANK( \uc8fc\ubb38[\uace0\uac1d] )<\/td>\uc11c\ub85c \ub2e4\ub978 \uace0\uac1d\uc774 \uba87 \uba85\uc778\uac00(\ube48 \uac12 \uc81c\uc678)<\/td>3<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 2: \ud569\uacc4 \uc904\uc774 \uc18c\uacc4\uc758 \ud569\uacfc \ub2e4\ub974\ub2e4<\/h2>\n\n
    \ubd84\ub958\ubcc4 \uace0\uac1d \uc218\ub97c \ud45c\ub85c \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
    \ubd84\ub958<\/th>\uace0\uac1d\uc218(DISTINCTCOUNT)<\/th>\ud574\ub2f9\ud558\ub294 \uace0\uac1d<\/th><\/tr><\/thead>\n
    \ub178\ud2b8\ubd81<\/td>2<\/td>\uae40, \uc774<\/td><\/tr>\n
    \ub9c8\uc6b0\uc2a4<\/td>3<\/td>\uae40, \ubc15, \uc774<\/td><\/tr>\n
    \ubaa8\ub2c8\ud130<\/td>1<\/td>(\ube48 \uac12)<\/td><\/tr>\n
    \ud569\uacc4<\/strong><\/td>4<\/strong><\/td>\uae40, \uc774, \ubc15, (\ube48 \uac12)<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \uc138 \uc904\uc744 \ub354\ud558\uba74 2 + 3 + 1 = 6\uc778\ub370 \ud569\uacc4 \uc904\uc740 4\uc785\ub2c8\ub2e4. \uc624\ub958\uac00 \uc544\ub2d9\ub2c8\ub2e4. \uae40\uacfc \uc774\ub294 \ub178\ud2b8\ubd81\uacfc \ub9c8\uc6b0\uc2a4 \uc591\ucabd\uc5d0\uc11c \uad6c\ub9e4\ud588\uae30 \ub54c\ubb38\uc5d0 \ubd84\ub958\ubcc4\ub85c\ub294 \uac01\uac01 \ud55c \ubc88\uc529 \uc138\uc5b4\uc9c0\uc9c0\ub9cc, \uc804\uccb4\ub85c \ubcf4\uba74 \ud55c \uc0ac\ub78c\uc785\ub2c8\ub2e4. Microsoft \ubb38\uc11c\ub3c4 \uace0\uc720 \uac12 \uac1c\uc218\uc758 \ud569\uacc4\ub294 \ub354\ud574\uc9c0\ub294 \uac12\uc774 \uc544\ub2c8\ub77c\uace0 \ub530\ub85c \uc124\uba85\ud558\uace0, \ud569\uc774 \ub9de\uc544\uc57c \ud558\ub294 \uacbd\uc6b0\ub77c\uba74 COUNT\ub098 COUNTROWS\ucc98\ub7fc \ud589\uc744 \uc138\ub294 \ud568\uc218\ub97c \uace0\ub824\ud558\ub77c\uace0 \uc548\ub0b4\ud569\ub2c8\ub2e4. \ub2e4\ub9cc \uadf8 \ud568\uc218\ub4e4\uc740 “\ud589 \uc218”\ub97c \uc138\ub294 \uac83\uc774\ub77c \uc758\ubbf8\uac00 \ub2e4\ub974\ub2e4\ub294 \uc810\ub3c4 \ud568\uaed8 \uc9da\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc6d4\ubcc4\ub85c \ub098\ub204\uc5b4\ub3c4 \uac19\uc740 \uc77c\uc774 \uc0dd\uae41\ub2c8\ub2e4. 3\uc6d4 \uace0\uac1d\uc740 \uae40\uacfc \uc774\ub85c 2\uba85, 4\uc6d4 \uace0\uac1d\uc740 \ubc15, \ube48 \uac12, \uc774\ub85c 3\uba85\uc785\ub2c8\ub2e4. \ub450 \ub2ec\uc744 \ub354\ud558\uba74 5\uc778\ub370, \uc804\uccb4 \uace0\uac1d \uc218\ub294 4\uc785\ub2c8\ub2e4. \uc774\uac00 3\uc6d4\uacfc 4\uc6d4 \uc591\ucabd\uc5d0 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc774 \uac12\uc740 “\uc6d4\ubcc4 \ud65c\uc131 \uace0\uac1d \uc218”\ub85c\ub294 \uc62c\ubc14\ub974\uc9c0\ub9cc, \uc774\uac83\uc744 \ub354\ud574\uc11c “\uc5f0\uac04 \uace0\uac1d \uc218”\ub97c \ub9cc\ub4e4\uba74 \ud2c0\ub9bd\ub2c8\ub2e4.<\/p>\n\n
    \uc6d4\ubcc4\ud65c\uc131\uace0\uac1d = DISTINCTCOUNTNOBLANK( \uc8fc\ubb38[\uace0\uac1d] )<\/code><\/pre>\n\n\n\n
    \uc6d4<\/th>\uc6d4\ubcc4\ud65c\uc131\uace0\uac1d(\ube48 \uac12 \uc81c\uc678)<\/th>\ud574\ub2f9\ud558\ub294 \uace0\uac1d<\/th><\/tr><\/thead>\n
    3\uc6d4<\/td>2<\/td>\uae40, \uc774<\/td><\/tr>\n
    4\uc6d4<\/td>2<\/td>\ubc15, \uc774<\/td><\/tr>\n
    \ud569\uacc4<\/td>3<\/td>\uae40, \uc774, \ubc15<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n
    \ube48 \uac12\uc744 \ube80 \uc6d4\ubcc4 \ud65c\uc131 \uace0\uac1d\uc740 \ub450 \ub2ec \ubaa8\ub450 2\uba85\uc774\uace0, \ud569\uacc4 \uc904\uc740 3\uba85\uc785\ub2c8\ub2e4. 2 + 2 = 4\uc640 3\uc740 \ub2e4\ub985\ub2c8\ub2e4. \uc774 \ucc28\uc774\uac00 \uace7 “\ub450 \ub2ec \uc5f0\uc18d\uc73c\ub85c \uad6c\ub9e4\ud55c \uace0\uac1d”(\uc774)\uc774 \uc911\ubcf5\ub418\uc5b4 \uc138\uc5b4\uc9c4 \uc815\ub3c4\uc785\ub2c8\ub2e4. \ubcf4\uace0\uc11c\uc5d0\uc11c \uc774 \ucc28\uc774\uac00 \uc911\uc694\ud55c \uc774\uc720\ub294, \ud569\uacc4\ub97c \ubcf4\uace0 “\uc6d4\ubcc4 \uc22b\uc790\uac00 \ud2c0\ub838\ub098?” \ud558\uace0 \uc758\uc2ec\ud558\uae30 \uc27d\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc9c8\ubb38\uc774 “\uadf8 \ub2ec\uc5d0 \uad6c\ub9e4\ud55c \uace0\uac1d\uc774 \uba87 \uba85\uc778\uac00”\ub77c\uba74 \uc6d4\ubcc4 \uac12\uc774 \ub9de\uace0, “\uae30\uac04 \uc804\uccb4\uc5d0\uc11c \uad6c\ub9e4\ud55c \uace0\uac1d\uc774 \uba87 \uba85\uc778\uac00”\ub77c\uba74 \ud569\uacc4 \uc904\uc774 \ub9de\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 3: \uc870\uac74\uacfc \ud568\uaed8 \uc138\uae30, \uadf8\ub9ac\uace0 \uace0\uac1d\ub2f9 \ud3c9\uade0 \uc8fc\ubb38 \uc218<\/h2>\n\n
    \ub9c8\uc6b0\uc2a4\ub97c \uc0b0 \uace0\uac1d \uc218\ub294 CALCULATE\ub85c \uc870\uac74\uc744 \ubc14\uafd4\uc11c \uc149\ub2c8\ub2e4. CALCULATE\uac00 \ud544\ud130\ub97c \ubc14\uafb8\ub294 \uc6d0\ub9ac\ub294 CALCULATE \ud568\uc218 \uae00<\/a>\uc5d0 \uc815\ub9ac\ud574 \ub450\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n\n
    \ub9c8\uc6b0\uc2a4\uad6c\ub9e4\uace0\uac1d\uc218 =\nCALCULATE(\n    DISTINCTCOUNT( \uc8fc\ubb38[\uace0\uac1d] ),\n    \uc8fc\ubb38[\ubd84\ub958] = \"\ub9c8\uc6b0\uc2a4\"\n)<\/code><\/pre>\n\n
    \ub9c8\uc6b0\uc2a4 \uc8fc\ubb38\uc740 2\ubc88(\uae40), 4\ubc88(\ubc15), 6\ubc88(\uc774)\uc774\ub77c \uacb0\uacfc\ub294 3<\/strong>\uc785\ub2c8\ub2e4. \ub610 “\uace0\uac1d \ud55c \uba85\uc774 \ud3c9\uade0 \uba87 \ubc88 \uc8fc\ubb38\ud588\ub294\uac00”\ub294 \uc8fc\ubb38 \uac74\uc218\ub97c \uace0\uc720 \uace0\uac1d \uc218\ub85c \ub098\ub204\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n
    \uace0\uac1d\ub2f9\ud3c9\uade0\uc8fc\ubb38\uc218 =\nDIVIDE(\n    COUNT( \uc8fc\ubb38[\uace0\uac1d] ),\n    DISTINCTCOUNTNOBLANK( \uc8fc\ubb38[\uace0\uac1d] )\n)<\/code><\/pre>\n\n
    \uace0\uac1d\uc774 \uc801\ud78c \uc8fc\ubb38 5\uac74\uc744 \uace0\uc720 \uace0\uac1d 3\uba85\uc73c\ub85c \ub098\ub204\ub2c8 5 \u00f7 3 = \uc57d 1.67<\/strong>\uc785\ub2c8\ub2e4. \ubd84\uc790\uc640 \ubd84\ubaa8\uc5d0\uc11c \ube48 \uac12\uc744 \uac19\uc740 \uae30\uc900\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \ubd84\uc790\uc5d0 COUNTROWS( \uc8fc\ubb38 )(6)\uc744 \uc4f0\uace0 \ubd84\ubaa8\uc5d0 DISTINCTCOUNTNOBLANK(3)\ub97c \uc4f0\uba74 6 \u00f7 3 = 2\uac00 \ub418\uc5b4, \uace0\uac1d\uc774 \uc5c6\ub294 \uc8fc\ubb38\uae4c\uc9c0 \uace0\uac1d\ub2f9 \uc8fc\ubb38\uc73c\ub85c \uacc4\uc0b0\ud558\ub294 \uc624\ub958\uac00 \uc0dd\uae41\ub2c8\ub2e4. \uc774 \uac12\uc740 \uc7ac\uad6c\ub9e4 \uc815\ub3c4\ub97c \uac00\ub2a0\ud558\ub294 \uac04\ub2e8\ud55c \uc9c0\ud45c\ub85c \uc790\uc8fc \uc4f0\uc785\ub2c8\ub2e4.<\/p>\n\n
    COUNTROWS\uc640 DISTINCT\ub85c \ud480\uc5b4 \uc4f0\uae30<\/h2>\n\n
    DAX Guide\uc5d0 \ub530\ub974\uba74 \uc544\ub798 \ub450 \uc2dd\uc740 \uac19\uc740 \uacb0\uacfc\ub97c \ub0c5\ub2c8\ub2e4.<\/p>\n\n
    DISTINCTCOUNT( \uc8fc\ubb38[\uace0\uac1d] )\nCOUNTROWS( DISTINCT( \uc8fc\ubb38[\uace0\uac1d] ) )<\/code><\/pre>\n\n
    \uadf8\ub798\uc11c DISTINCTCOUNT\ub294 “\uace0\uc720 \uac12 \ubaa9\ub85d\uc744 \ub9cc\ub4e0 \ub4a4 \ud589 \uc218\ub97c \uc13c\ub2e4”\ub294 \ub73b\uc73c\ub85c \uc77d\uc73c\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n
    \uc131\ub2a5: \uc65c \ub290\ub9b4 \uc218 \uc788\uc744\uae4c<\/h2>\n\n
    SQLBI\uc758 \ubd84\uc11d\uc5d0 \ub530\ub974\uba74 DISTINCTCOUNT\ub294 \ud569\uacc4\ucc98\ub7fc \uc911\uac04 \uacb0\uacfc\ub97c \ud569\uccd0\uc11c \uad6c\ud560 \uc218 \uc5c6\ub294 “\ube44\uac00\uc0b0” \uc9d1\uacc4\ub77c\uc11c, \ubcf4\uace0\uc11c\uc758 \uac01 \uc140\ub9c8\ub2e4 \ub530\ub85c \uacc4\uc0b0\ud574\uc57c \ud558\ub294 \ubd80\ub2f4\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc5f4\uc758 \uace0\uc720 \uac12\uc774 \ub9e4\uc6b0 \ub9ce\uac70\ub098(\uce74\ub514\ub110\ub9ac\ud2f0\uac00 \ub192\uac70\ub098), \uc140\ub9c8\ub2e4 \uc11c\ub85c \ub2e4\ub978 \ud544\ud130\uac00 \uc801\uc6a9\ub418\ub294 \ubcf5\uc7a1\ud55c \ubcf4\uace0\uc11c\uc5d0\uc11c\ub294 \ub290\ub824\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac19\uc740 \uae00\uc740 \ub2e8\uc21c\ud55c \ubcf4\uace0\uc11c\uc5d0\uc11c\ub294 DISTINCTCOUNT\uac00 \ub300\uccb4\ub85c \ub0ab\uace0, \ub290\ub9ac\ub2e4\uace0 \ub290\uaef4\uc9c8 \ub54c\ub294 DAX Studio \uac19\uc740 \ub3c4\uad6c\ub85c \uc2e4\uc81c \uc131\ub2a5\uc744 \uce21\uc815\ud55c \ub4a4\uc5d0 \ub2e4\ub978 \ubc29\uc2dd\uc744 \uace0\ub824\ud558\ub77c\uace0 \uad8c\ud569\ub2c8\ub2e4. \uadfc\uc0ac\uac12\uc73c\ub85c \ucda9\ubd84\ud558\ub2e4\uba74 DAX Guide\ub294 APPROXIMATEDISTINCTCOUNT\ub77c\ub294 \ub300\uc548\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<\/p>\n\n
    \uc4f0\uc9c0 \ub9d0\uc544\uc57c \ud560 \ub54c<\/h2>\n\n
      \n
    • \ub2e8\uc21c\ud788 \ud589 \uc218\uac00 \ud544\uc694\ud560 \ub54c<\/strong>: COUNTROWS\uac00 \uc54c\ub9de\uc2b5\ub2c8\ub2e4.<\/li>\n
    • \uc18c\uacc4\ub97c \ub354\ud574\uc11c \ud569\uacc4\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud560 \ub54c<\/strong>: \uace0\uc720 \uac12 \uac1c\uc218\ub294 \ub354\ud574\uc9c0\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n
    • \ube48 \uac12\uc774 \uc11e\uc778 \uc5f4\uc5d0\uc11c “\uc0ac\ub78c \uc218”\ub97c \uc140 \ub54c<\/strong>: \ube48 \uac12\uc744 \ube84\uc9c0 \uc815\ud558\uc138\uc694. \ube7c\ub824\uba74 DISTINCTCOUNTNOBLANK\uc785\ub2c8\ub2e4.<\/li>\n
    • \uace0\uc720 \uac12\uc774 \uc218\ubc31\ub9cc \uac1c\uc778 \uc5f4\uc744 \uc5ec\ub7ec \uc140\uc5d0\uc11c \ubc18\ubcf5 \uacc4\uc0b0\ud560 \ub54c<\/strong>: \uc18d\ub3c4\ub97c \uba3c\uc800 \uc810\uac80\ud558\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
      • 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. DAX Guide\ub294 \uce21\uc815\uac12\uacfc \uacc4\uc0b0 \uc5f4\uc5d0\uc11c \uc9c0\uc6d0\ub41c\ub2e4\uace0 \uc801\uc5b4 \ub450\uc5b4 \uc124\uba85\uc774 \ub2e4\ub974\ub2c8, \uc4f0\ub294 \ud658\uacbd\uc5d0\uc11c \uc9c1\uc811 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/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. \ube48 \uac12\uc774 \ud558\ub098 \ub354 \uc138\uc5b4\uc838\uc11c \uc0ac\ub78c \uc218\ubcf4\ub2e4 1 \ud06c\uac8c \ub098\uc634<\/strong>: \ube48 \uac12\uc744 \ube84\uc9c0 \uc815\ud558\uc138\uc694. \ube7c\ub824\uba74 DISTINCTCOUNTNOBLANK\uc785\ub2c8\ub2e4.<\/li>\n
        2. \ud569\uacc4 \uc904\uc774 \uc18c\uacc4\uc758 \ud569\uacfc \ub2e4\ub974\ub2e4\uace0 \uc624\ub958\ub85c \ud310\ub2e8<\/strong>: \uace0\uc720 \uac12 \uac1c\uc218\ub294 \uc6d0\ub798 \uadf8\ub807\uc2b5\ub2c8\ub2e4.<\/li>\n
        3. \uc8fc\ubb38 \uac74\uc218\ub97c \uace0\uac1d \uc218\ub85c \ucc29\uac01<\/strong>: \ud55c \uc0ac\ub78c\uc774 \uc5ec\ub7ec \ubc88 \uc8fc\ubb38\ud558\uba74 \ub450 \uac12\uc740 \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/li>\n
        4. \ubd84\uc790\uc640 \ubd84\ubaa8\uc758 \ube48 \uac12 \ucc98\ub9ac \uae30\uc900\uc774 \ub2e4\ub984<\/strong>: \ube44\uc728\uc744 \uad6c\ud560 \ub54c \uae30\uc900\uc744 \ud1b5\uc77c\ud558\uc138\uc694.<\/li>\n<\/ol>\n\n
          \ube44\uc2b7\ud55c \ud568\uc218<\/h2>\n\n
            \n
          • DISTINCTCOUNTNOBLANK<\/strong>: \ube48 \uac12\uc744 \uc138\uc9c0 \uc54a\ub294 \ud615\ud0dc<\/li>\n
          • COUNTROWS, COUNT, COUNTA<\/strong>: \ud589 \uc218\uc640 \uac12\uc774 \uc788\ub294 \ud589 \uc218<\/li>\n
          • DISTINCT, VALUES<\/strong>: \uace0\uc720 \uac12 \ubaa9\ub85d\uc744 \ud14c\uc774\ube14\ub85c \ub3cc\ub824\uc8fc\ub294 \ud568\uc218<\/li>\n<\/ul>\n\n
            \uc815\ub9ac<\/h2>\n\n
            DISTINCTCOUNT\ub294 “\uc11c\ub85c \ub2e4\ub978 \uac12\uc758 \uac1c\uc218”\ub97c \uc138\ub294 \ud568\uc218\uc774\uace0, \ube48 \uac12\ub3c4 \ud558\ub098\uc758 \uac12\uc73c\ub85c \uc13c\ub2e4\ub294 \uac83\uacfc \ud569\uacc4\uac00 \uc18c\uacc4\uc758 \ud569\uacfc \ub2ec\ub77c\uc9c4\ub2e4\ub294 \uac83, \uc774 \ub450 \uac00\uc9c0\uac00 \ud575\uc2ec\uc785\ub2c8\ub2e4. \uc9c8\ubb38\uc774 \uc0ac\ub78c \uc218\uc778\uc9c0 \uac74\uc218\uc778\uc9c0, \uadf8\ub9ac\uace0 \uc6d4\ubcc4 \uac12\uacfc \uae30\uac04 \uc804\uccb4 \uac12 \uc911 \ubb34\uc5c7\uc744 \ubb3b\ub294\uc9c0\ubd80\ud130 \uc815\ud558\uba74 COUNTROWS\uc640 DISTINCTCOUNT \uc911 \ubb34\uc5c7\uc744 \uc4f8\uc9c0 \uc790\uc5f0\uc2a4\ub7fd\uac8c \uc815\ud574\uc9d1\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, DISTINCTCOUNT function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/distinctcount-function-dax<\/li>\n
            • Microsoft Learn, DISTINCTCOUNTNOBLANK function (DAX): https:\/\/learn.microsoft.com\/en-us\/dax\/distinctcountnoblank-function-dax<\/li>\n
            • DAX Guide, DISTINCTCOUNT: https:\/\/dax.guide\/distinctcount\/<\/li>\n
            • SQLBI, Analyzing the performance of DISTINCTCOUNT in DAX: https:\/\/www.sqlbi.com\/articles\/analyzing-distinctcount-performance-in-dax\/<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
              DAX DISTINCTCOUNT \ud568\uc218\uc758 \ube48 \uac12 \ucc98\ub9ac, \ud569\uacc4\uac00 \uc18c\uacc4\uc758 \ud569\uacfc \ub2ec\ub77c\uc9c0\ub294 \uc774\uc720, \uc6d4\ubcc4 \ud65c\uc131 \uace0\uac1d\u00b7\uc870\uac74\ubd80 \uac1c\uc218\u00b7\uace0\uac1d\ub2f9 \ud3c9\uade0 \uc8fc\ubb38 \uc218 \uc2dc\ub098\ub9ac\uc624\uc640 \uc131\ub2a5 \ucc38\uace0\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,13,6],"class_list":["post-29","post","type-post","status-publish","format-standard","hentry","category-power-bi","tag-dax","tag-distinctcount","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\/29","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=29"}],"version-history":[{"count":1,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":38,"href":"https:\/\/vera-b.com\/index.php?rest_route=\/wp\/v2\/posts\/29\/revisions\/38"}],"wp:attachment":[{"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vera-b.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}