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

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.

Reply
gra_wang
Helper I
Helper I

Quarterly Average over Weekly Average

I'm trying to create a line and clustered chart where the clusters/bars show weekly averages while the lines show quarterly averages.

Graph.JPG
Here is the measure I used to try to get a quarterly average:

Quarterly Average Talk Time =
AVERAGEX(
    SUMMARIZE(subAgentCall,subAgentCall[Quarter],subAgentCall[skill_name],subAgentCall[Call Type],"Average Talk Time",
    (SUM(subAgentCall[SUM TT])/SUM(subAgentCall[Calls Handled]))/60),[Average Talk Time])

Problem is (as indicated by the picture above), all that happens is the line matches the weekly average. Is it possible to create a measure that calculates strictly at the quarterly level and utilize it on a graph using weekly intervals?



1 ACCEPTED SOLUTION

@gra_wang,

 

Drag [Quarter] on top of [Week], and select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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