Joinning two tables in dax code

[Anonymous]

I'm new in dax and here is my question; I have two tables(sql views) in tabular:

Fact table
Key_col1	Prodnr	col1
101	P0005	517
102	P0037	620
103	P0074	240

and in table2 

Dimension table
Key_col2	col2	col3
102	620	PE412
101	517	AE309
103	240	EF903

In tabular I've created a relation between two tables with their key columns and want to write a dax code that when I select for example P0074 from a slicer , it shows EF903 as a part of information in report. 

[lbendlin]

If you want to do this in DAX you need to use either LOOKUPVALUE or TREATAS.

Why not do this in the model view though?

[Anonymous]

I resolved it by creating a new view.