Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |