Add column from another Table

[MMQuestions7]

Hi,

I have 2 tables (with relationship) – Table_A, Table_B.

I added “Table_B” column (IDT) to Table_A.

IDT Copy = RELATED(Table_B[IDT]).

The issue is Table_A consists of Dates and when IDT Copy, it will displayed in every row.
Latest Date eg. 5 rows. I only need to get 1 row record.

Date	Total Sales	IDT
27/4/23	100	50
27/4/23	100	50
27/4/23	100	50
27/4/23	100	50
27/4/23	150	50
TOTAL:	550

Actual Total = [Total Sales]- [IDT]
                      = 550 – 50
                      = 500

Can someone suggest how to solve this? or any simple solution for this?

Thank you

[MMQuestions7]

Hi, Thank you for the suggestion. I managed to do it using measure. thank you.

[lbendlin]

I added “Table_B” column (IDT) to Table_A.

Please explain that decision.  Pulling dimension fields into a fact table should be limited to scenarios where it is absolutely required (for example when you have non-covering or degenerate dimensions).  In most cases the correct approach is to fix the data quality of your dimension table.