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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

How to : Matrix Average values and sum subtotal

Hi eveybody,

I have some values like this

tgz666_0-1663831797101.png

and Matrix Object like that

tgz666_1-1663831856283.pngtgz666_2-1663831876099.png

For each REF i have the monthly average (OK, it's what i want) but for the PTF subtotal i wish the sum of averages not the average

for example : PTF1/202202 (aaaaa+bbbbb = 6.00+3.50) = 9.50 not 4.75

How can i do that ?

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Unfortunatly, isn't ok sub total PTF isn't equal to sum(ref)

tgz666_0-1663854550460.png

I have found an another method with transformation data : Group By

= Table.Group(#"Added Custom", {"PTF", "yyyymm", "REF"}, {{"ValueMoy", each List.Average([Value]), type nullable number}})

tgz666_1-1663854736959.png

It's ok

 

 

View solution in original post

2 REPLIES 2
serpiva64
Super User
Super User

Hi,

try this measure

Measure = if (HASONEVALUE('Table'[REF]),AVERAGE('Table'[Value]),calculate(AVERAGE('Table'[Value]), ALL('Table'[Date])))
 
you will obtain this
serpiva64_0-1663836154532.png

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution !

 

Anonymous
Not applicable

Unfortunatly, isn't ok sub total PTF isn't equal to sum(ref)

tgz666_0-1663854550460.png

I have found an another method with transformation data : Group By

= Table.Group(#"Added Custom", {"PTF", "yyyymm", "REF"}, {{"ValueMoy", each List.Average([Value]), type nullable number}})

tgz666_1-1663854736959.png

It's ok

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.