Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Implementing USERELATIONSHIP on measures for different date columns

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

Need Help
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Solved!

     

  • Pertunia's avatar
    Pertunia
    Regular Visitor
    3 years ago

    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.