Forum Discussion

smashbroski's avatar
smashbroski
Regular Visitor
6 years ago
Solved

Count dont display as days on chart / table

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

Need Help
Show and Tell
  • smashbroski's avatar
    smashbroski
    6 years ago

    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.

2 Replies