Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Dear PowerBI community,
I need your help once again.
I have a powerBI table that contains multible columns. I have visuals where I sort on a button on the visuals page by date where the datetable is related to the created on date.
Now I need to show a visual that is counting the average for the response time for reply send to the customer on a specific date (red arrow). This is a bit tricky as the front page is sorting via the datetable to the created on date (yellow arrow).
I have created a relation between the date when the response was send and the datetable.
But my DAX creations are not working well for my measure to be shown on the frontpage.
Can any of you assist?
needed measure: For each unique ID - header notification number to the right. The expression shall calculate the average responsetime for the first response in workingdays. Each ID, should only be counted once.
My measure:
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |