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.
Hello all,
I am trying to create a chart that would show changes in service tickets.
I do have a dataset that shows me the ticket numbers for each day, i.e.
What I would like my chart to show not only the sum of distinct ticket numbers per day, but also, that on 2019-10-02, there was one ticket closed and one new ticket opened...
Would there be a way to show the inflow / outflow of tickets in a chart?
I think what I would need to do is to create some sort of comparison between (current_date) and ((current_date) - 1) where I would be comparing the distinct ticket numbers and highlight the differences. I know how I could do this in Excel, but I certainly wouldn't want to get back on that train... Any help would be appreciated!
Hi @_n_MarianLein ,
To create two measures as below.
count = CALCULATE(DISTINCTCOUNT('Table'[Ticket I
D]),ALLEXCEPT('Table','Table'[Date]))
difference = VAR d = MAX ( 'Table'[Date] ) - 1 VAR c = CALCULATE ( DISTINCTCOUNT ( 'Table'[Ticket ID] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) ) VAR a = CALCULATE ( DISTINCTCOUNT ( 'Table'[Ticket ID] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] = d ) ) RETURN IF ( a = BLANK (), BLANK (), c - a )
Hi,
Unfortunately this does not do what I want it to do - The measure delivers some numbers, but they don't make sense when I look at the date.
What happes for me is that the "Difference" always shows a value above what I would be expecting...
To better visualize what I would like to have, I have attached some anonymized data to show what I'm looking at, so you can reference it...
What I would like to see now, is:
- In case a ticket ID was not present the day before: Add "IN" (or something similar) in the "Action" column
- In case a ticket ID was not present the day after: Add "OUT" in the "Action" column
- In other cases: Add nothing to the "Action" column
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.