Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |