Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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] ) )
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] ) )
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
You just have to create another measure with same logic as previous one replacing VALUES( Table[Product] ) with VALUES( Table[Week] )
sorry i wasn't clear, i mean an average function that takes into account both columns, product and week
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])