Compare Daily Total with Day of Week Average

[noircrk]

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:

True Assign = COUNTROWS( 'Assign Data' )

True Assign by Day = AVERAGEX(DISTINCT('DtKey'[DtKey]),CALCULATE(COUNTROWS('Assign Data')))

Thank you for you time and consideration!

[amitchandak]

@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())

[noircrk]

Thank you, @amitchandak .

What is the [Week Year] output or the dax to create it.  I currently have a [Week Number]=

VALUE( YEAR( 'DtKey'[Week End] ) & FORMAT( WEEKNUM( 'DtKey'[Week End] ), "00" ) )