-
Notifications
You must be signed in to change notification settings - Fork 0
/
Calculate Function.dax
39 lines (31 loc) · 1.46 KB
/
Calculate Function.dax
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
// The Calculate Function
// Solution Request from VP
// Maven Analytics
// Request 1
// Sales Managers and VPs are raising concersn about the number of bike returnds they're seeing recently
// Finding out Bike Sales
Bike Sales = CALCULATE
([Quantity Sold], // Measure
'Product Categories Lookup'[CategoryName] = "Bikes" // Filter
)
// Answer: 427 bikes
// Finding out Bike Returns
Bike Returns = CALCULATE
([Total Returns], // Measure
'Product Categories Lookup'[CategoryName] = "Bikes" // Filter
)
// Answer: 13,929 bikes sold
// Finding out Bike Return Rate
Bike Return Rate = CALCULATE
([Return Rate], // Measure
'Product Categories Lookup'[CategoryName] = "Bikes" // Filter
)
// Answer: Return rate of 3.08%
// In Conclusion: there has not been a spike in returns considering out quantity of
// bikes sold.
// Request 2
// Create two new measures, one to call ALL returns (regardless of filter context and another that divides Total Returns by All returns
// that should allow us to see the % of returns by different products and product categories
All Returns = CALCULATE([Total Returns], all('Returns Data')) // creating the measure to
Percent of All Returns = DIVIDE([Total Returns],[All Returns])
// The highest return rate goes to Accesories with 61.64% and Clothing with the lowest at 14.76%