average of measure evaluated for eachrow

[Nouha]

Hello, 

I have a data set that looks this way

Product     Sales      Original_Stock      %Sold

X                 8                    16                   50%

Y                  10                  150                  7%

Z                 2                      6                    33%

% sales is a calculated value 

I want to calculate a function that gives me the average of the % sold in a card visualization

if I use the fast calculations available in power bi it gives me 12% which is sum(sales)/sum(original_stock)

while i want the average of % sales evaluated for each row so average (50% ; 7%; 33%) which is 30%

i hope my problem is clear, 

thank you

Nouha 

[AkhilAshok · Accepted solution]

Something like this maybe:

Total Sales = SUM(Table[Sales])
Total Stocks = SUM(Table[Original_Stock])
% Avg Stock = AVERAGEX ( VALUES ( Table[Product] ), DIVIDE ( [Total Sales], [Total Stocks] ) )

[Nouha]

Thank you so much , this works perfectly

i have an extra question on the subject 

imagine we have a week column , and i want to calculate the average the same way but per week . how would i proceed ?

thank you 

[AkhilAshok]

You just have to create another measure with same logic as previous one replacing VALUES( Table[Product] ) with VALUES( Table[Week] )

[Nouha]

sorry i wasn't clear, i mean an average function that takes into account both columns, product and week

[AkhilAshok]

You could use ALL(Table[Product], Table[Week]). But this will clear any filter context existing in Product or Week. If you want to preserve the filter context, you could use SUMMARIZE(Table, Table[Product], Table[Week])