temporary table with unique values with calculatetable

[Artefact]

Hi ,

I'm trying to make a temporary table to use with SUMX. 1 with unique id's. The base table has many non unique id's. All the rows with the same id have the same value in another column.

My idea was CALCULATETABLE(tablename,(VALUES(tablename[id])))
but this returns the whole basetable with all non unique id's. So all the rows.

When I omit the tablename as the first parameter, of course the other columns are not there, but at least the one-column table has only the unique id.

How can a make a table with 2 columns : one with the unique key and the corresponding other value in the other column?

So from this

id	value	other misc
1	10	ags
1	10	saaas
1	10	sasaS
2	5	REEWWR

To this :

id	value
1	10
2	5

[Jos_Woolley]

No worries, glad to help!

Cheers

[Jos_Woolley · Accepted solution]

Not sure I'm not missing something, but I would have thought you could use simply:

New Table =
SUMMARIZE(
    'Table',
    'Table'[id],
    'Table'[value]
)

Regards

[Artefact]

Jos, thanks for the quick reply. I stubbornly focussed on the wrong path....