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 All,
I have the below data set for sales for which I am trying to get a percentage of sales in measure.
Store ID | Sales Date | Daily sales | Total Employees |
101 | 1/1/2021 | 5 | 9 |
101 | 1/1/2021 | 8 | 9 |
101 | 1/1/2021 | 10 | 9 |
102 | 1/1/2021 | 7 | 11 |
102 | 1/1/2021 | 5 | 11 |
102 | 1/1/2021 | 11 | 11 |
102 | 1/1/2021 | 8 | 11 |
102 | 1/1/2021 | 12 | 11 |
I want to have Perctenage KPI which calculates Store Total Sales / Total Employees. For example, for Store 101 my measure will return (5+8+10)/9 = 2.55 so on and so forth...
By default, I would like to have a value that returns data for all stores. In above example. All the sales will be summed (66) and then divided by (9+11) = 20 and the result should show as 3.3
Any guidance will be helpful.
Thanks,
@Anonymous , Try a measure like
divide(sum(Table[sales]), sumx(values(Table[Store ID]), calculate(max(Table[Total Employees]))))
or try like
averageX(summarize(Table, Table[Store ID] , "_1", sum(Table[sales]) , "_2",calculate(Max(Table[Total Employees]))), divide([_1],[_2]))
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |