Count dont display as days on chart / table

[smashbroski]

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

[Greg_Deckler]

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

[smashbroski · Accepted 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.