Forum Discussion

CraigC's avatar
CraigC
Icon for Helper I rankHelper I
8 years ago
Solved

Opened vs closed column chart with date filter

Hi All,   I am trying to create something like the below where i can compare how many incidents were opened per a day and how many incidents were closed per day. I have a column called Open Date an...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    create a measure for closed incident using userelationship function like below and use this on visual

     

    Closed Incidents = 
Calculate(Count(Table1[Incident]),
UseRelationship(Table1[CloseDate], Calendar[Date])
)
CraigC's avatar
CraigC
Icon for Helper I rankHelper I
8 years ago

Ok so i have a date table with both my opened incidents and closed incidents linked to the date column. The closed incident column being an inactive link with the opened incidents being the active link. If i create the graph now it will display the same info for the opened and closed incidents. How do i go about linking the closed incidents column now to show the right data?

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

create a measure for closed incident using userelationship function like below and use this on visual

 

Closed Incidents = 
Calculate(Count(Table1[Incident]),
UseRelationship(Table1[CloseDate], Calendar[Date])
)
  • CraigC's avatar
    CraigC
    Icon for Helper I rankHelper I
    8 years ago

    Sorry for the late reply but worked perfectly thank you :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This is exactly the problem i am stuck with, i tried to use your solution but it did not work in my power bi template. Can i please contact you about this problem?

  • Wkbdrguy's avatar
    Wkbdrguy
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Been trying to use this formula but trying not to count rows for closed dates that are blank as the incidents are not closed yet.