Measure w/ userelationship not showing values

[Anonymous]

Hello, 

I have a table with two different dates, request date and completion date. My calendar table has an active relationship to the compledtion date and inactive relationship to the request date.

I would like to create a chart comparing the number of jobs completed in a month vs number of jobs requested in a month.

To do so I created the below measures: 

Jobs By Comp Date: COUNTA(Data_Submitted[JOB ID]

Jobs By Req Date: CALCULATE( [Jobs by Comp Date], USERELATIONSHIP('Data_Submitted'[Request Date], 'Calendar'[Date]))

When I put the measures into a chart, no values appear for "Jobs By Req Date". Is there something wrong with my measure or relationship?

Thank you in advance! 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I create a sample demo using your formulas and everything is working fine.

It's better to share your data model so that we could check the formula for you.

Best Regards,

Jay

[AllisonKennedy]

@Anonymous  What Date are you using in the Chart? Make sure you're using the Date table Calendar[Date], but otherwise everything looks ok.