Remove / disable duplicates in table visual

[Florex]

Hey,

I have a problem where I can't get any further.

This is a table visual which is filtered for ID: "123", there are differents Names and Values - (Value) do not care.

I want a IF function, that if the ID and den Name of the Component Equal there should only display one column 

-> in the Case it dosent matter which column from Component A remains (KC or XF - doesnt matter)

ID	Name	Value
123	Component A	KC
123	Component A	XF
123	Component B	LJM
123	Component C	LJK

It should look like this:

ID	Name	Value
123	Component A	KC
123	Component B	LJM
123	Component C	LJK

or like this:

ID	Name	Value
123	Component A	XF
123	Component B	LJM
123	Component C	LJK

[samratpbi]

in addition to the above, you may create a simple measure and use that measure instead of the value column also: 

Max Val = MAX(Component[Value])

[ryan_mayu · Accepted solution]

@Florex 

you can set the value to first or last

[Florex]

such a easy solution - thank you 

[ryan_mayu]

you are welcome