measure to count from another table (not relationed tables) - very challenging

[Anonymous]

Hi !

I have two tables and i can´t relation them because they are many to many.

Table 1

Course Name | Goal

Law                 | 2

Medicine        | 3

Table 2

Law

Law

Law

Medicine

Law

Medicine

Medicine

What is my expected result (Count if)

Course Name | Goal | Count from Table 2

Law                 | 2      |           4

Medicine        | 3      |            3

How can i Creat a measure for this ? I want to show as a Matrix in my power bi, like above..

Many thanks guys!!

[PaulDBrown · Accepted solution]

@Anonymous 

Create two measures:

1) Sum of Goal = SUM(Table 1 [Goal])

2) count of course = CALCULATE(COUNT(Table 2 [Course]), TREATAS(VALUES(Table 1 [Course]), Table 2 [Course]))

create the matrix with the rows from Table 1 [Course] as rows and add both measures.