Non distinct (duplicate) values in DAX dropdown

[sumittal]

Hi,

I am seeing duplicate values when I click on the dropdown arrow to filter values. This is only happening with some columns. 

As example - One of the columns in a table is the currency of transaction. Several rows of entry have CHF as currency value. When I click on the arrow to filter rows based on currency, I see duplicated options as follows, beating the purpose of filtering function. Please advice what am I doing incorrect.  

GBP 

[v-xicai]

Hi @sumittal ,

You may create a new calculated column like DAX below, and apply it in your visuals.

Distinct Currency Value= DISTINCT(Table1[Currency Value])

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sumittal]

Thanks @v-xicai 

For no known reason, but the functionality is working fine today.

Adding a new distinct coumn to the same table might not have worked as it would have resulted in multiple output error. Thats because my table has several rows with duplicated values that I need to retain. I just needed the dropdown list to show distinct values. 

Regards, 

Sumittal

[Wimverh]

I can't think of reason how to create this. 
Can you check in transformation what column type you have selected, and see if the column distribution is OK:

[sumittal · Accepted solution]

Thank you @Wimverh 

For no know reason, the drop down is working fine today - as expected. I attach new screenshot. 

With my little knowledge of Power BI I woud have struggled to correclt implement your advice. I would definitely like to add that the table was created combining two tables in M-query and then the currency column was added in DAX using LOOKUPVALUE function, along with several other columns added at DAX stage. All columns from M-query stage worked as expected (with distinct values appearing in the dropdown) but all columns added in DAX were showing duplicate values. 

Thanks, 

Sumittal