Forum Discussion

Caiz's avatar
Caiz
Frequent Visitor
5 years ago
Solved

Combining Values to Display in a Line Chart

I am new to Power BI, and have a line chart that I would like to display the tickets that are marked with the status: Open and Closed/Resolved. Closed and Resolved are different statuses, however I w...
DAX
Need Help
  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    5 years ago

    works fine for me, can you share how you writed the dax? 

StefanoGrimaldi's avatar
StefanoGrimaldi
Resident Rockstar
5 years ago

works fine for me, can you share how you writed the dax? 

Caiz's avatar
Caiz
Frequent Visitor
5 years ago

Thanks for your help, it works now! I changed it from SUM to COUNT:

Closed & Resolved = CALCULATE(COUNT('Tickets'[Status]), 'Tickets'[Status] = "Closed") + CALCULATE(COUNT('Tickets'[Status]), 'Tickets'[Status] = "Resolved")