Subtotal averaged instead of sum

[Analitika]

I use this measure

SuperAveage =

VAR multiplier =

IF (

SELECTEDVALUE('units'[MAT_12]) <> BLANK ();

SELECTEDVALUE('units'[MAT_12]);

1

)

VAR sResult =

DIVIDE(

[AllSubNamePrice];

[AllSubNameCount]

) * multiplier

RETURN

sResult

But in total i got not Sum but average probably. So how to get Sum in subtotal?

[Anonymous]

HI @Analitika,

I'd like to suggest you take a look at the following blog about measure calculation on the total level and add if statement to check the current row contents level. Then you can write a specific formula with aggregate function to achieve different aggregate on the total level:

Measure Totals, The Final Word  
Regards,

Xiaoxin Sheng

[amitchandak]

@Analitika , You need to group data until a level and then take a sum. Use summarize or values

example

sumx(summarize(table,table[group],"_1",[SuperAveage]),[_1])

sumx(values(table[group]),[SuperAveage])

Or

https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

[vanessafvg]

can you give more information about what you are trying to do, its not entirely clear. sharing some data is also useful