Loading only a few fields of another query

[Bebs]

Hello, I'd like to create a table which contains only the distinct value of a few fields of another table,

is it possible ?

[Bebs]

Thanks for your suggestions,

@ToddChitt :  yes, that's it, Summarize works exactly the way I'm looking for. Is it possible to use this SUMMARIZE function to create a new table in the model or is it limited to the layout ? (I need to build the table in the model).

[ToddChitt · Accepted solution]

@Bebs Not sure what you mean by "in the model" or "limited to the layout". Can you clarify your question?

The SUMMARIZE is a DAX statement/function that can be used to create a new table that is a summary of another. It can be used in-line in other DAX statements/funcitons that accept a table object as an input parameter, or used by itself to create a whole new table that can be added to visuals, filters, relationships, etc. 

[Bebs]

OK thanks,

in fact, I didn't knew the Data/Table tools/New table way to build a table using DAX.

it works 🙂

Thx

[Jayaselvan]

Please share us some sample table's snapshot and you're expected output snapshot. So that we can help on creating the Formula itself. If possible please share the PBI file itself (Incase you don't  want to share the orginal file, please mimic into simple pbi file ). That makes our task very easy. And we can help very precisely. 

[ToddChitt]

Try the DAX SUMMARIZE function. It creates a new table that, well, summarizes another table.