topic Re: Distinct count vs countrows summarize/group by in DAX Commands and Tips

Distinct count vs countrows summarize/group by

xum — Wed, 26 Mar 2025 13:42:09 GMT

Hi,

In my model i got a column that's 50% of DB, that column was imported from SQL and it's the concatenation of column A, B, C, D (they are all integer).
I just use that column to get a measure with distinct count.

Instead of import that column, i just import the C and D column (A and B were already imported) with much less cardinality and reduce the size of my model.

And in my new measure i use:
countrows (Groupby A, B, C, D) instead of distinct count, but this one is a killer performance in DAX, we are talking about a table with 80M.

I'm not sure if that's confused or not.
Any suggestion or work around?

Thanks for ur time 🙂

Re: Distinct count vs countrows summarize/group by

Deku — Wed, 26 Mar 2025 20:25:26 GMT

You can try the below, you might get a better query plan. Check the server timings in DAX studio for the various options.

Sumx(

summarize(

Table,

Table[a],

Table[b],

Table[c],

Table[d]

)

Re: Distinct count vs countrows summarize/group by

Anonymous — Wed, 02 Apr 2025 11:44:44 GMT

Hi xum,

Thanks Deku for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

Re: Distinct count vs countrows summarize/group by

Anonymous — Mon, 07 Apr 2025 11:39:36 GMT

Hi @xum,

Regards,
Vinay Pabbu

Re: Distinct count vs countrows summarize/group by

Anonymous — Fri, 11 Apr 2025 13:23:47 GMT

Hi xum,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu