Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi@ axy5093 

You don’t 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:

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