Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

How to : Matrix Average values and sum subtotal

Hi eveybody, I have some values like this and Matrix Object like that For each REF i have the monthly average (OK, it's what i want) but for the PTF subtotal i wish the sum of aver...

Anonymous
3 years ago
Unfortunatly, isn't ok sub total PTF isn't equal to sum(ref)
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}})
It's ok

Icon for Solution Sage rank

Solution Sage

3 years ago

Hi,

try this measure

Measure = if (HASONEVALUE('Table'[REF]),AVERAGE('Table'[Value]),calculate(AVERAGE('Table'[Value]), ALL('Table'[Date])))

you will obtain this

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

3 years ago

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

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

It's ok

Related content