@Anonymous wrote:
Hi, While combining two records into one. I used "Text.Combine". This worked and now my question is how to get the count of records which were used for merging into a single record.
Quoting the example below
Existing:
Column1 . Column2
------------------------
1000 abc
1000 xyz, lmn
post combine
Column1 . Column2
------------------------
1000 abc, xyz, lmn
Now.. need to understand how many records were there before merging into one using DAX
Regards
Found the solution
1. Select the column and point your mouse point on (...) and select "New Quick Measure"
2. In the popup window, select the listbox on the left and look for "Concatenated List of Values" in "Text" header
.. it should work
If you want to sum/difference ... on column1.. then
1) use the same step
2) Under "Mathematical Operations" select "Addition"
