Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using related in a measure

Hi,   I have a simple query where i count the no. issues closed during each month and hence i created a date table and have a n:1 (GetIssue[Closed_date] : DateKey[Date])relationship with my date ta...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this measure

     

    =CALCULATE(DISTINCTCOUNT(GetIssues[id]),USERELATIONSHIP(GetIssues[Closed_date],DateKey[Date]))

     

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

I'd like to suggest you take a look at following blog to know how to use userelationship function in calculate column:

USERELATIONSHIP in Calculated Columns

 

If above not help, can you please share some sample data to test?

 

Regards,

Xiaoxin Sheng