Table issue

[vjnvinod]

Dear all,

@amitchandak  @Anonymous 

I am using below Dax to create a new table

Rank = UNION(DISTINCT(FY20WTD_MTD_YTD[Rank Description]),DISTINCT('YTD FY21'[Rank Description]))

But this is returning me duplicate and blank values as welll, is there way i can fix this?

[v-easonf-msft]

Hi, @vjnvinod 

You need to apply “distinct” function to the "Rank" table again.

Please create another calculated table based on the table 'Rank'：

Rank2 = DISTINCT(FILTER('Rank','Rank'[Rank Description]<>""))

The result ( without any duplicate and blank values) will show as below:

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@vjnvinod ,

Try

Distinct(Rank = UNION(DISTINCT(FY20WTD_MTD_YTD[Rank Description]),DISTINCT('YTD FY21'[Rank Description])))

or

distinct(Rank = UNION(all(FY20WTD_MTD_YTD[Rank Description]),all('YTD FY21'[Rank Description])))