INDEX function error

[kivancc94]

Hi,

I wanted to try new Dax function INDEX. But I received an error. What could be the reason ?

Data;

I wanted to create a new table with one row which includes highest profit. But "Relation parameter may have duplicate rows." error occured.

Thanks a lot in advance. 

[Kannan_n]

Hi @kivancc94

The syntax for writing DISTINCT (Column) Function:

DISTINCT(<column>)

Where,

Column- It is a column from which unique values are to be returned.

Ex. DISTINCT([ProductPrice])

It returns the unique values from the column ‘Prod uctPrice’.

If this resolve the problem please give a like and make the question as resolve 

Thanks and Regards 

Kannan.N