Forum Discussion

yliu371's avatar
yliu371
Frequent Visitor
2 years ago

General question

Let's say I have 2 tables with the followings -

TABLE 1 has one column called "DEPT NAME" and it has 2 records DEPT_NAME_A and DEPT_NAME_B. 

TABLE 2 has 3 columns with column DATE and the other 2 columns are named as "DEPT_NAME_A" and "DEPT_NAME_B".

DATE is used as a filter in visual. 

 

I want to build a matrix that shows DEPT NAME and the values from TABLE 2 (DEPT_NAME_A and DEPT_NAME_B) as shown below -

DEPT NAME                        VALUEs from TABLE 2

-----------------------------------------------------------

DEPT_NAME_A                                 1

DEPT_NAME_B                                 2

 

What DAX function should I use?  Any suggestion would be appriciated.  

Thanks

 

 

2 Replies

    • yliu371's avatar
      yliu371
      Frequent Visitor

      sorry for the confusion.

      1 and 2 are the records of TABLE 2 columns.