topic Combining Values to Display in a Line Chart in DAX Commands and Tips

Combining Values to Display in a Line Chart

Caiz — Thu, 21 Jan 2021 22:58:14 GMT

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!

Re: Combining Values to Display in a Line Chart

StefanoGrimaldi — Fri, 22 Jan 2021 01:13:10 GMT

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.

Re: Combining Values to Display in a Line Chart

Caiz — Fri, 22 Jan 2021 02:23:34 GMT

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

Re: Combining Values to Display in a Line Chart

StefanoGrimaldi — Fri, 22 Jan 2021 02:38:11 GMT

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

Re: Combining Values to Display in a Line Chart

Caiz — Fri, 22 Jan 2021 02:47:39 GMT

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