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.
Hello Everyone,
I'm trying to display a chart of closed Incidents by date, and while I can get two of my measures to do so, I can't seem to get the third. See below:
I'm surprised that even with my TTL Closed Resolved Measure below that it show ttl's by day, but not the TTL Active. The measures are below:
INC_TTLClosedResolved =
CALCULATE(
DISTINCTCOUNT('Incidents'[Incident ID]),
'Incidents'[Status] IN { "Resolved", "Closed" }
)
INC_TTLActive =
CALCULATE(
DISTINCTCOUNT('Incidents'[Incident ID]),
'Incidents'[Status] IN { "Assigned", "Pending", "Work in Progress" }
)
I have a Calendar with Dates that have relationships to the proper tables, but any help on why this isn't working will be appreciated
Cheers
Solved! Go to Solution.
I've actually figured it out.
I'm so new to this Power BI World that I watched this video and was able to determine that my Relationships were going the wrong way (much like real life)
Once I moved the relationships to the right direction Completed Date to my Date in my Date Calendar, it all started working like it was supposed to.
Extremely difficult to tell what is going on here. Sample source data might make it clearer along with expected output. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But maybe a version of Open Tickets??? https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147
I've actually figured it out.
I'm so new to this Power BI World that I watched this video and was able to determine that my Relationships were going the wrong way (much like real life)
Once I moved the relationships to the right direction Completed Date to my Date in my Date Calendar, it all started working like it was supposed to.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |