Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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
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
Solved! Go to Solution.
Hi,
Try this measure
=CALCULATE(DISTINCTCOUNT(GetIssues[id]),USERELATIONSHIP(GetIssues[Closed_date],DateKey[Date]))
Hi,
Try this measure
=CALCULATE(DISTINCTCOUNT(GetIssues[id]),USERELATIONSHIP(GetIssues[Closed_date],DateKey[Date]))
Thank you! I had initially tried this out but when i combine it with additional filters it wouldnt work. Am not sure if my query with filters and calculate is wrong For example :
ClosedBugs = CALCULATE(DISTINCTCOUNT(GetIssues[id]),FILTER(GetIssues,'GetIssues'[issuetype] ="Bug" && 'GetIssues'[Priority] in {P1,P2} ,USERELATIONSHIP(GetIssues[Closed_date],DateKey[Date]))
Hi,
Try this
=CALCULATE(DISTINCTCOUNT(GetIssues[id]),'GetIssues'[issuetype]="Bug",'GetIssues'[Priority]="P1"||'GetIssues'[Priority]="P1", ,USERELATIONSHIP(GetIssues[Closed_date],DateKey[Date]))
I settled for adding filters under the visual filters, and just using distinct count and userelationship.
Got stuck with a new problem, am trying to calculate backlog bugs i.e all bugs created before the next month but closed after next month.
My query is the following but i think am going wrong with the order of precendence/filter because my values are way off.
backLogBugs = CALCULATE(DISTINCTCOUNT(GetIssues[id]),Filter(GetIssues, (GetIssues[created]< Related(DateKey(StartofNextMonth) && GetIssues[customfield_10030] > Related(DateKey(StartofNextMonth)) || (GetIssues[created] < Related(DateKey(StartofNextMonth) && GetIssues[status.name] <> "Closed"))
Thanks for you help!
Hi,
I am not clear. Share some data and show the expected result.
Hi @axy5093,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |