Forum Discussion
Distinct count vs countrows summarize/group by
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 wi...
Deku
Super User
Super UserYou 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]
)
,1
)