User Profile
glearner
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: Average by group
Excellent danextian, thanks so much. We are making great progress, but clearly there is some context transitioning knowledge that eludes me, since using the allselected does not produce the intended final outcome. I managed to get the $/Hour thanks to you, but now the sumx is producing an unexpected outcome, I was expecting to see 1.3 x 2 = 2.6 for the first store Moreover, the card with the same measure also produces the incorrect results, as I was expecting it to sum said multiplication for each store and delivery partner combination. Measures defined below: 1. Shift = Sum(DeliveryMetrics[Shift]) 2. $/h: Var D_TotalOnlineHours = CALCULATE([D_OnlineHours],ALLSELECTED('Date')) Var D_TotalRevenue = CALCULATE([D_DeliverySales],ALLSELECTED('Date')) Var D_SalesPerHour = DIVIDE(D_TotalRevenue,D_TotalOnlineHours,"") return D_SalesPerHour multiplication: SUMX(DeliveryMetrics,[Shift]*[$/h]) Thanks for your ongoing support; I sincerely hope that with your assistance I can understand how this works and put the report to restAverage by group
Hi I have a fact table that contains online hours by day, store, and partner platform. The fact tables has a 1:* relationship coming from Dims Storekey,PartnerKey, and DateKey How can I calculate the total online hours by store & partner, across the entire selected date range (via slicer - not influenced by the visual) I've tried with several variations of ALL filters by clearly my knowledge is limited and I fail to produce the intended outcome. Once I get the total online hours I would like to use it to caclulate the total Sales by Hour (I'll replicate the approach for total sales by Hour) which will ultimately give me the Average Sales by Hour per group; ultimately multiplying this by another measure the offline hours and producing the Lost Sales due to Downtime. Can anyone assist me in produce the sales by partner & Store across the entire selected date range>?
