topic Re: DISTINCTCOUNT in DAX Commands and Tips

DISTINCTCOUNT

wyanjaspew — Wed, 12 Apr 2023 04:03:06 GMT

Hi Everyone,

Please help me on this. TA

FreemanZ — Wed, 12 Apr 2023 04:59:43 GMT

it seems you want a measure, but actually creating a calculated table. or?

wyanjaspew — Wed, 12 Apr 2023 05:06:18 GMT

oh got it, doesn't applicable on creating table. thanks FreemanZ!

FreemanZ — Wed, 12 Apr 2023 05:15:46 GMT

if you want the distinct list, try like:

DISTINCT(Table[Col])

VALUES(Table[Col])

ALL(Table[Col])