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])
)
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi CraigC,

 

Have you tried the solution provided by parry2k above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. :smileyhappy:

 

Regards

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

Worked perfectly thank you. I just added the current month filter to the date table and everything works.