Two tables in one dataset: Compare and Analyze

[matvey364]

Hi all,

I am really strugling with something, and would appreaciate any help. I have 2 tables in one dataset:

Table One: List of users with a unique idintifier who have completed courses. One user can be listed multiple times as he completed different courses.

Table Two: Master list of users with a unique identifier + a set of additional fields. Every user is listed once.

I am trying to build visuals/analytics on how many % of users from Table Two have completed specific course from Table 1 and filter it by fields in Table two, like country and etc. I am also trying to generate list from Table two who HASN'T completed a specific course and is not listed in Table TWO.

Any help would be greatly appreaciated.

[v-juanli-msft · Accepted solution]

Hi @matvey364 

Create relationship between two tables

create meausres in table two

Measure = IF(MAX('table one'[user id])=MAX('table two'[user id]),1,0)

Measure 2 = COUNTX(FILTER(ALLSELECTED('table two'),[Measure]<>0),[Measure])

Measure 3 = CALCULATE(COUNT('table two'[user id]),ALLSELECTED('table two'))

Measure 4 = [Measure 2]/[Measure 3]

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.