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? 

Caiz's avatar
Caiz
Frequent Visitor
5 years ago

Hi Stefano, if I used calculate I get the error: "A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

 

Same with FILTER:

 

"function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

 

I have used this:

 

ClosedResolved = CALCULATE(SUM('Tickets'[Status]), FILTER ('Tickets', 'Tickets'[Status] = "Closed") + CALCULATE(SUM('Tickets'[Status]), FILTER ('Tickets', 'Tickets'[Status] = "Resolved")))

 

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")