cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
axy5093 Regular Visitor
Regular Visitor

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 many:1 (GetIssue[Closed_date] : DateKey[Date])relationship with my date table and this is an inactive relationship so i use USERRELATIONSHIP. But my final values seem to be very less. Any insight will be helpful 

 

PowerBI.PNGDate table

Query :

ClosedBugs = CALCULATE(DISTINCTCOUNT(GetIssues[id]),FILTER(GetIssues,'GetIssues'[Closed_date] >=RELATED(DateKey[StartofCurrentMonth]) && 'GetIssues'[Closed_date]< RELATED(DateKey[StartofNextMonth]),USERELATIONSHIP(GetIssues[Closed_date],DateKey[Date])) 

 

 

Thanks,

Aishwarya

1 REPLY 1
Community Support Team
Community Support Team

Re: Using related in a measure

Hi@ axy5093 

You dont need to use related in your measure ,you can just use this measure

ClosedBugs = CALCULATE(DISTINCTCOUNT(GetIssues[id]))

And two columns

Year=Year('GetIssues'[Closed_date] )
Month = Month('GetIssues'[Closed_date] )

Then drag the  Year ,Month and measure into Table visual like below:

1.png

If it is not your case, please share pbix file or some data sample and expected output . You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.