Forum Discussion

Agpretty20's avatar
Agpretty20
New Member
5 years ago

Unable to use second inactive user relationship

Hello , Having trouble with 2nd userelationsip, Seek assistance Below is the first userelationship which is working without any issue CALCULATE(COUNTA(vw_MSR_CC_ChangeReport[Change number]),USERELATI...
Dashboards
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Agpretty20 , Can this type of measure works for you

 

CALCULATE(COUNTA(vw_MSR_CC_ChangeReport[Change number]),USERELATIONSHIP(vw_MSR_CC_ChangeReport[Planned start date],'Date-Hirarchy'[Date]))
+
CALCULATE(COUNTA(vw_MSR_CC_ChangeReport[Change number]),USERELATIONSHIP(vw_MSR_CC_ChangeReport[Assignment group],vw_MSR_Task_Tbl[Assignment group]))

Agpretty20's avatar
Agpretty20
New Member
5 years ago

Hello Amit,

 

Thank you for reaching out with a possible solution. The calculation you provided will not work , it will add those additional numbers. Please let me know if we can try anything else! Thanks!

 

Regards,

-Alicia