Distinct count of concatenated columns

[General Ledger]

I am trying to create a measure of the distinct count of combinations (concatenations) of columns.

I can concatenate two fields to create a new calculated column KEY =[ChartID] & "-" & [Date]
I can then create a measure DCOUNTKEY = DISTINCTCOUNT(KEY)

Can I do these two steps as one and not burden my model with a low cardinal calculated column?

I tried =CONCATENATEX(Sales, [ChartID] & "-" & [Date], ", ") which does get me a string of items separated by comas but then cannot figure out how to count them.

I tried =VALUES(CONCATENATEX(Sales, [ChartID] & "-" & [Date], ", ")) but that does not work.

Any ideas?????
Thank you.

 

[Ozeroth]

Hi there,

A couple of ways you could define a measure for a distinct count of combinations of Date and ChartID (I'm assuming all your columns are in the Sales table):

=
SUMX ( VALUES ( Sales[ChartID] ), CALCULATE ( DISTINCTCOUNT ( Sales[Date] ) ) )

=
COUNTROWS ( SUMMARIZE ( Sales, Sales[ChartID], Sales[Date] ) )

 

[General Ledger]

Both Work Perfectly!!

My hacks were not even close to your slick solutions.

Thank You!!!