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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

keep the average in a matrix table for the quarters

Dear All,

 

I have the below table:

month

Country

FTEs

1/1/2019

Germany

1

1/1/2019

Germany

0.7

1/1/2019

Germany

0.7

1/1/2019

Germany

1

1/2/2019

Germany

1

1/2/2019

Germany

0.7

1/2/2019

Germany

0.7

1/2/2019

Germany

1

1/3/2019

Germany

1

1/3/2019

Germany

0.7

1/3/2019

Germany

0.7

1/3/2019

Germany

1

   

 

all I want is when i am creating a matrix table (column dates), for the quarters to appear as an average and not a sum.

 

Is there any measure on that?

 

Thank you in advance,

 

Paris

1 ACCEPTED SOLUTION
Anonymous
Not applicable

7 REPLIES 7
Anonymous
Not applicable

thats the answer

Capture.PNG

Anonymous
Not applicable

Hi Ppatris,

 

Please find attached screenshot.Try to change the property of FTEs as Average under Values Section.Check it out in attachments.

Regards,

Rupesh Dhage

1.PNG2.png3.PNG

 
Anonymous
Not applicable

Even in Quarter level ,it is fetching Avg value.

 

Regards,

Rupesh Dhage4.PNG

az38
Community Champion
Community Champion

Hi @Anonymous 

if i understand you correct it's an unusual behaviour.

try to set Sum in the field property or share to us (screenshot or pbix file) what are you seeing incorrectly

414260.png

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

hi @az38 ,

 

Below you have a example of a Matrix Table.

 

Month:

Capturem.PNG

Quarter:

Captureq.PNG

 

Those are the same tables just for the months I have drill down. 

 

What I want is when you I drill up to the quarters and years to see the average of the selected months and not the sum. so the amount that I would like to see on this specific case would be 1445.18 / 3 = 481.72. 

In case I have 2 months of info just to be divided by 2 and same to happen when i drill up to the year.

 

Let me know in case you would like more info and i would be happy to send them to you.

 

Cheers,

az38
Community Champion
Community Champion

@Anonymous 

am I correct: you need the SUM by month, but the AVG of the Monthly sums for quarters?


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

hi @az38 

 

Yes exactly and as well the AVG of the Monthly sums for the year but i believe thats the same as the quarters.

 

thank you,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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