Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All, I'm struggling with showing a daily total next to a day of the week average. I've seen similiar posts regarding totals vs averages but I either don't understand the solution or am unable to adapt it to my situation. Any assistance is greatly appreciated.
Assuming a date range of 03/29/2023 - 04/06/2023. I can get the average by day of week "True Assign by Day" and the daily total "True Assign", as shown in the first table. However, in the second table I want to show the "True Assign by Day" average from the first table to the daily "True Assign" in the second table. But when I add the measure to the second table is mirrors the "True Assign" value.
Ultimately I need to compare the daily total against the average of that day of week for the date range selected. The Business case is thus, Is today's (4/6/2023) volume of 502 higher or lower than the average Thursdays of 497 in the range selected?
Formulas:
Thank you for you time and consideration!
@noircrk , have week year column in your date table, have measures like
True Assign by Day = calculate(AVERAGEX(Value('DtKey'[DtKey]),CALCULATE(COUNTROWS('Assign Data'))), allselected())
True Assign by Week = calculate(AVERAGEX(Value('DtKey'[Week Year]),CALCULATE(COUNTROWS('Assign Data'))), allselected())
Thank you, @amitchandak .
What is the [Week Year] output or the dax to create it. I currently have a [Week Number]=
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |