Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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?
I resolved it by creating a new view.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |