DAX to create new column from distinct values of other two columns in the same table

[KoalaPBI]

Hi Community,

How can I create a new column (NOT Table) from distinct values of other two columns in the same table?

Thanks!

[AbbasG]

Hi, @KoalaPBI 

I have tried with some sample data, which may help you.

Step 1: Create a conditional column to identify if the values are distinct or not.
If value1 <> value2 then 1 else 0

Step 2: Add visual level filter to show only distinct values. i.e.1

Attached pbix for your reference.- https://1drv.ms/u/s!ArEx6MabNbWofjwTj6Ampd8nC9s?e=lCOBLy

[KoalaPBI]

@AbbasG thanks, but this is not what I am trying to achieve.

Let me explain a bit on what I expect: 

So, the new column is a union(distinct(values(col1)),distinct(values(col2))