Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |