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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
---|---|
15 | |
11 | |
6 | |
6 | |
5 |
User | Count |
---|---|
29 | |
17 | |
11 | |
7 | |
5 |