Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to Solution.
works fine for me, can you share how you writed the dax?
Proud to be a Super User!
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.
Proud to be a Super User!
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?
Proud to be a Super User!
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")
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 10 |