Force Aggregation to a specified dimension

[MichaelWinz]

I am attempting to implement a measure that averages a count over the day of the week for a specified time period.   When I used Tableau I was able to accomplish his with Level of Detail calculations.   It seems like some combination of CountX and AverageX would do the same in PowerBI.  I just can't wrap my brain around how to approach this problem. 

Here's an example of what I've tired.  

Visit Count By Day of Week = AVERAGEX( Values('PatientFlow StatusOrderBASE'[Date - Day of Week]), Calculate(DISTINCTCOUNT('PatientFlow StatusOrderBASE'[VisitID] )))

The attached visual is a total count for each day.  I'd like to see the average count for a specifed time period for a specific day of the week.  

[v-yangliu-msft]

Hi  @MichaelWinz ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Weekday = WEEKDAY('Table'[Date])

2. Create measure.

Measure =
AVERAGEX(FILTER(ALLSELECTED('Table'),'Table'[Weekday]=MAX('Table'[Weekday])),[Value])

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[MichaelWinz]

This doesn't work in my situation.   The measure being summed is always 1.    What I need is an Average of Sums Across WeedDays.