Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
gjelstrup
Helper I
Helper I

Average of data with multible data, sorted by a response date in another column

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). 

gjelstrup_0-1688412185098.png

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. 

 

gjelstrup_1-1688412479626.pnggjelstrup_2-1688413466266.png

My measure: 

LCG LCG KPI first response (w.days) = calculate(AVERAGEX(DISTINCT('Global Notifications'[Header - Notification Number (N)]), FIRSTNONBLANK('Global Notifications'[LCG KPI First response w.days], 0)))
 
However, now comes the tricky part where it shall calculate the average of all the IDs where there were a first response for example in June (a specific dateinterval, as determined on the visual side as shown above) independent on when the ID was created. 
The below "preset period" link is the description of the dateintervals as shown on the front page. 
('Preset Period'[cal Preset Value]=1), 
 
Below the relationship it needs to use for the calculation of the average value. 
USERELATIONSHIP(DateDim[Date],'Global Notifications'[LCG KPI First response date]))
 
For the above data, I need an average value of 9,20

 

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.