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

hey try a measure like this: 

measure = calculated(sum(columnvalue),status="Closed") + calculated(sum(columnvalue),status="Resolved")

 

if this solved your question please give some kudos and mark as solution for others to find it.  

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