Implementing USERELATIONSHIP on measures for different date columns

[Anonymous]

Hi,

I'm trying to create a line chart with running totals for three measures I created. 

The problem is my fact table has 3 date columns - I've created inactive relationships with my Date table but becuase the measures aren't straightforward I'm struggling. 

The data has the following headers:

Unforuntaley participant status is only reliable for two measures and for the other I have to count total rows and using COUNTA as the status randomisation can change later on. 

They are:

Total Randomised = COUNTA('Participant Details'[Randomisation Date])

Total Withdrawn Post-Rand = CALCULATE(COUNTROWS('Participant Details'),'Participant Details'[Subject Status]="Withdrawn Post-Rand") 

Total Completed = CALCULATE(COUNTROWS('Participant Details'),'Participant Details'[Subject Status]="Completed")

I can't get the USERELATIONSHIP to work, but I need to connect to the following columns:

Total Randomised is Randomisation Date

Total Withdrawn Post-Rand and Total Completed are Date of Completion / Withdrawal

Any ideas?

Best,

Soph

[Pertunia]

Hi Experts, I have been trying to group or split (can't find the exact word) the rows of the first column (PP_NO). I need to have 2 have two separate columns, one for 1 and the other for two. And also combine data of the same date in a column. 

Please advise how do i do that. 

[Anonymous · Accepted solution]

Solved!