Forum Discussion
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 would like to combine the values for each month's number of tickets marked as this because they basically have the same meaning.
How do I combine the Closed & Resolved values, so that it only displays as a single line instead of 2 separate ones (as shown below)?
I would appreciate your help!
works fine for me, can you share how you writed the dax?
4 Replies
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.
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")))works fine for me, can you share how you writed the dax?
